The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
When I plugged "MIN" into my first measure, the result comes up blank. Not sure what I am missing here. The next two measures are working pristinely, so I am assuming I oversimiplified the ending of my first measure. I have already calculated the difference between the two dates so I'm able to simplify part of the ACV% Change calc.
Here are my three measures:
ACV % Change = DIVIDE([Change in ACV] , [MIN])
Change in ACV =
VAR __max = MAXx('Calendar Table','Calendar Table'[Year])
VAR __min = MINx('Calendar Table','Calendar Table'[Year])
MIN =
VAR mind =
CALCULATE ( MIN ( 'Divya ACV'[Year] ), ALLSELECTED ( 'Divya ACV'[Year] ) )
RETURN
CALCULATE ( SELECTEDVALUE ( 'Divya ACV'[Product Value] ), 'Divya ACV'[Year] = mind )
Looking for help with my % Change.
Sorry I wasn't very clear. I am trying to calculate the difference between the min and max year. I'm afraid that measure is incorrect (see first measure out of the three listed above). Thanks for the response!