Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

dax

I have Month number as [Month], sales as Retailing , document_date and i want to display sales of last to last month. and another measure of sales prior to last to last month. These needs to be displ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago



i have sales of last year, this year , i have shown last month also but i'am not able to show last 2 last month and before that. these data should change dynamically whenever i select a month then these should change automatically rather than manually entering month for each measure. 

Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

Hi Anonymous 
Based on your data for 7,8,9,10 as month Number.I have created simple formula
I hope this is what you are looking for 
if you select 10 in slicer then 7,8,9,10 should be calcualted.

If I select 9 then 7,8,9 data should be summed up. because you have limited data.
Please create below measure for last 3 months calculation:

Cummuative 1 =
Var N= MAX('Table'[Month])-3
Var A=CALCULATE(SUM('Table'[Swing Sales]),'Table'[Month]>=N && 'Table'[Month]<=MAX('Table'[Month]))

 

I hope this is what you wanted. 
and If you want something like below image then its different calculation!
Based on your selection your measure should change the value.