Running totals on another running total measure

[vishnupriyak]

Hi everyone,

I am facing an issue with dax to calculate the running total on a running total measure.

Attaching my case.

First row is be my raw data. 

Second row is running total of first row. This was achieved.

But the 3rd row should be running total of 2nd row. Im unable to get this.

Jan	Feb	Mar	Aprl	May	Jun
2	3	4	5	2	8
2	5	9	14	16	24
2	7	16	30	46	70

Please help me on this.

Thanks in advance,

Vishnu Priya

[parry2k]

@vishnupriyak you should put the output based on the sample data, if you cannot do it, then not sure how you expect someone to help you.

[vishnupriyak]

@parry2k ,

Im sure about the desired output. And I have added the o/p snap for the raw data that I shared. 

And I think, I have explained the logic like, how the data should populate . 

Im again attaching the desired output.  

Thanks in advance,

Vishnu

[v-janeyg-msft]

Hi, @vishnupriyak 

This logic seems to be iteration, pbi is difficult to calculate iteration.

The sample you provided is inconsistent with the result you want. We can’t see what your original data contains and which ones you want to request.

If there is not much data, it is recommended that you directly add results to the source data. Using dax is complicated and unavailable.😊

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey

[parry2k]

@vishnupriyak not sure if the output you are showing is using the sample data, there is no January in the sample data?

[vishnupriyak]

@parry2k ,  Below is the desired o/p for my raw data.

Thanks,

Vishnu Priya

[vishnupriyak]

@parry2k , That output I showed is  just the format and the base calculations that should involve in that output.

Thanks,

Vishnu

[parry2k]

@vishnupriyak based on the sample data what will be your output?

[vishnupriyak]

Hi @parry2k ,

below  is  my desired  output.

Thanks in advance,

Vishnu

[vishnupriyak]

Hi @parry2k ,

 format of  my data will be in the below format.

Category	Date1	Cnt
A	23-09-2021	2
A	24-09-2021	3
A	14-09-2021	4
A	05-08-2021	4
A	06-07-2021	5
A	16-06-2021	7
A	14-05-2021	8
B	23-09-2021	2
B	24-09-2021	3
B	14-09-2021	4
B	05-08-2021	4
B	06-07-2021	5
B	16-06-2021	7
B	14-05-2021	8

Thanks,

Vishnu

[parry2k]

@vishnupriyak what is the structure of your raw data? Solution depends on it. paste raw data in a table format.