I want to create a new column (Cumulative sales)
any one provide the DAX for new column
Solved! Go to Solution.
What does your date column looks like ?
dd/mm/yyyy hh mm ss or only dd/mm/yyyy ?
This formula work for distinct rows, on a distinc index value.
So if you have a lot of sales each day and a row for each sales it won't work.
The solution will be to :
Either have a Index column (like Sale1; Sale2 that identify each sale)
Create a new table that use : Table = Summarize(YourTable;YourTable[Date];"Sales";SUM(YourTable[Sales]))
It will display the sum of your sales for each day. And when you will have this table you will be able to create a cumulative column with this table.
For your query this is the solution DAX
Actuals Budget = CALCULATE(
'Gross FCC'[Posting period (r)]<=MAX('Gross FCC'[Posting period (r)])
@ssvr Thank you so much for your solution. I was stuck at the same problem. I was using ALL so getting incorrect values then I replaced it with ALLSELECTED so Instantly I got the expected result.
Thanks a bunch buddy for your solution!
Thanks it works fine.
Check out the News & Announcements to learn more.
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.