Plot sale variance over a month

[VisheshVats]

Hello ,

I wish to plot the variance of current NAV-CHEASH to it's value 30 days back on a line chart. 

for instance if today is 5/9/2022, i wish to find the % difference from 6/8/2022 and plot it on a line chart. so that if i hover over the visual i can get the variance of that particular date. ie, if i hover over 1/9/2022 then i get the % difference from 6/8/2022.

[v-yadongf-msft · Accepted solution]

Hi @VisheshVats ,

Please try following DAX to create a new column:

Column = 
var _a = CALCULATE(SUM('Table'[NAV-CHAESH]),FILTER('Table','Table'[Date] = EARLIER('Table'[Date])))
var _b = CALCULATE(SUM('Table'[NAV-CHAESH]),FILTER('Table','Table'[Date] = MAX('Table'[Date])-31))
return
DIVIDE(_a,_b)-1

Please note: If you want it to go to 5/8/2022, MAX[Date] should minus 31.

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yadongf-msft]

Hi @VisheshVats ,

Sorry for the inconsistency in your description, your description is really confusing:

if today is 5/9/2022, i wish to find the % difference from 6/8/2022.

if i hover over 1/9/2022 then i get the % difference from 6/8/2022.

If i hover on 1/09/2022 it goes back to 1/8/2022 when i want it to go to 5/8/2022.

How many days ago do you want to get the value?

Thanks for your efforts & time in advance.

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VisheshVats]

my measure makes the -30 go back 30 days from the date selected. As in, If i hover on 1/09/2022 it goes back to 1/8/2022 when i want it to go to 5/8/2022,when the first date in the column is 5/8/2022.

I wish to fix the denominator value as -30 days from MAX [date].