Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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!