Forum Discussion
SVG Sparkline DAX Help
Measure123 = VAR XMaxDate = MAX('r1WoW'[Date])
VAR XMinDate = XMaxDate-30
// Obtain overall min and overall max measure values when evaluated for each date
VAR YMaxValue = MAXX(VALUES('r1WoW'[Date]),CALCULATE([Measure Value1]))
VAR YMinValue = MINX(VALUES('r1WoW'[Date]),CALCULATE([Measure Value1]))
I want YMinValue evaluted from last 30 days of max date instead 'r1WoW'[Date.Let me knwo coorect DAX for calulcating YMinValue
1 Reply
hi, atul9063
You may try to use “all” functions in the formula.
If not your case, please share some sample data and expected output.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Best Regards,
Lin
