topic Re: sum revenue (measure) for 12 month doesn't work in DAX Commands and Tips

sum revenue (measure) for 12 month doesn't work

Anonymous — Tue, 23 Apr 2024 12:56:02 GMT

Re: sum revenue (measure) for 12 month doesn't work

lbendlin — Wed, 24 Apr 2024 00:11:22 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: sum revenue (measure) for 12 month doesn't work

Anonymous — Wed, 24 Apr 2024 02:29:35 GMT

Hi Anonymous ,

lbendlin , thanks for your concern about this case. I tried to create a sample data myself based on the user is requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution:

I created sample data based on screenshot:

My understanding of your needs is this:

If my income in January is 100, my income in February is 200, and my income in March is 300, then use DAX syntax to achieve the following results:

The Total Revenue GBP RTM in January is 100, the Total Revenue GBP RTM in February is 100+200=300, and the Total Revenue GBP RTM in March is 100+200+300=600.

Is my understanding correct?

It is easy to achieve this requirement.

To create a calculated column, the DAX syntax is as follows:

Total Revenue GBP RTM = CALCULATE( SUM('Table'[Fee Monthly]), ALL('Table'), 'Table'[Date] <= EARLIER('Table'[Date]) )

Just drag the Total Revenue GBP RTM onto the table visual for display.

pbix file is attached.

If you have any further questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!