Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to calculate the cumulative sum per PERIOD_NAME and the sumulative sum per MFG_ORDER_NAME and PERIOD_NAME. Data I have is MFG_ORDER_NAME, PERIOD_NAME and TOTAL_COSTS_PER_JOB_IN_PERIOD. See table. The last column is the value I want to calculate if the cumulative costs per MFG_ORDER_NAME are calculated per period.
Can anyone advise which DAX formula(s) this can solve?
Thanks in advance.
Hi @Hyperchef1969
Hope you are doing well.
I am struggling with a similar problem. Just wanted to find out if you've maybe managed to solve it?
Kind regards
Hi @Hyperchef1969,
Based on my test, you could refer to below steps:
Add index column for your data in query editor:
And create below calculated column:
Cumulative sum = CALCULATE(SUM(Table1[Value]),FILTER('Table1','Table1'[Index]<=EARLIER(Table1[Index])&&'Table1'[MFG_ORDER_NAME]=EARLIER(Table1[MFG_ORDER_NAME])))
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi,
Unfortunatel I a working in DirectQuery mode, so insert an index is not supported within direct query.
However I managed to calculate the **bleep**.costs per MFG_ORDER_NAME by following calculation (Period_CHAR recalculated to a date field called PERIOD_MID_DATE)
Printscreen of solution:
Question is the following: When I visualize the total costs of PERIOD_NAME_CHAR, so MFG_ORDER_NAME is not included, the total does not match. Total for December 2018 should be 7789542 (export from Power BI to excel - second printscreen below) while total is represented in Power BI as 8321509. See first printscreen. Why is there a difference and how to solve this?
Hi, can someone help please!!! Let me know if something is not clear.
Thanks in advance
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
104 | |
76 | |
70 | |
50 |
User | Count |
---|---|
146 | |
107 | |
106 | |
89 | |
65 |