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!
User | Count |
---|---|
98 | |
76 | |
76 | |
48 | |
26 |