Forum Discussion
Solved
Grouped Sum
I have a summarized table like this: Year ProdFacName Department Name Week Total_WCM_EUs 2020 Tyler WCM 29 563892.44 2020 Tyler WCM 30 589533.76 I would like to create a ...
Hi sprakash1192 ,
Or you can use "earlier" function:
Total = SUMX(FILTER('Table','Table'[Key]=EARLIER('Table'[Key])),'Table'[Total_WCM_EUs])And you will see:
For the related .pbix file,pls see attached.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
But it takes away all groups. I should have made my question clearer, I want to have a grouped sum by the Key in my table, like this :
| Year | ProdFacName | Department Name | Week | Key | Total_WCM_EUs | Total |
| 2020 | Tyler | WCM | 29 | 29-30 | 563892.4 | 1153426 |
| 2020 | Tyler | WCM | 30 | 29-30 | 589533.8 | 1153426 |
| 2020 | Tyler | WCM | 31 | 31-32 | 410000 | 9410000 |
| 2020 | Tyler | WCM | 32 | 31-32 | 9000000 | 9410000 |
Hi sprakash1192 ,
Or you can use "earlier" function:
Total = SUMX(FILTER('Table','Table'[Key]=EARLIER('Table'[Key])),'Table'[Total_WCM_EUs])And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Kelly
Did I answer your question? Mark my post as a solution!