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
Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Anonymous 
Please provide the expected output in form of matrix visual. you can calculate in excel share the that table here to understand how you want to see the data. 
how much data will be there when you want to display in table visual.

 

I hope you know what I am asking.

 

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
    Icon for Community Champion rankCommunity 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.