Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to create a new calculated row from previous row

Hi,   Can you please help me to achieve the below:   I have a below table: C1 C2 C3 C4 zzzzz India 01/01/2019 250 zzzzz India 01/02/2019 676 zzzzz India 01/03/2019 33 ...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

hi Anonymous 

You could also try this simple measure

Measure = CALCULATE(SUM('Table'[C4]),DATEADD('Table'[C3].[Date],-1,MONTH))+SUM('Table'[C4])

Then drag it into matrix visual and set "show on rows"

 

and here is sample pbix file, please try it.

 

Regards,

Lin

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Lin,

     

    Thank you so much for your solutions. I checked the file you attached and its working as I expected.

    I tried to apply the same logic in my original file and not getting the expected output. I am getting the sum of current month data instead of prev month + current month. for example, Jan month data is 200 and  Feb  is 250 then I am getting 500 instead 450.

    I couldn't able to attach my file here. I checked all the settings in your file and compared with me but I couldn't get what is the issue. can you help me on this pease?

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Its working fine now. Thank you.