Skip to main content
Microsoft Idea

Power BI

Needs Votes

Quick Measure - monthly Min/max for previous 12 months

Vote (0) Share
Power BI Ideas Admin's profile image

Power BI Ideas Admin on 23 Jan 2020 08:36:28

Quick measures to determine monthly Min/max for previous 12 months and or current year.

Even better if i'm using a date hierarchy, use the next level down of date. IE Hierarchy is Year, month, Day. At Year show Monthly calc, at month show daily calc.