SVG Sparkline DAX Help

[atul9063]

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

[v-lili6-msft]

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/38490

Best Regards,

Lin