Forum Discussion
calculated column by column ID
Hi all,
I am trying to create a new calculated column in PowerBI that will take the sum of volume by ID. Any suggestions?
Thanks!!!
Hi puj831,
From your description, I thought the sum of ID=3 should be 228(43+23+24+43+31+64), right? If so, you could refer to below steps:
1.I have entered some sample data like the picture below:
2.Create a calculated column and you can see the result.
Column = CALCULATE(SUM(Table1[Volume]),FILTER('Table1','Table1'[ID]=EARLIER(Table1[ID])&&'Table1'[Ciyt]=EARLIER(Table1[Ciyt])))
You can also download the PBIX file to have a view.
https://www.dropbox.com/s/ciybodnwcinfxnw/calculated%20column%20by%20column%20ID1.pbix?dl=0
Regards,
Daniel He
2 Replies
Hi puj831,
could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
Hi puj831,
From your description, I thought the sum of ID=3 should be 228(43+23+24+43+31+64), right? If so, you could refer to below steps:
1.I have entered some sample data like the picture below:
2.Create a calculated column and you can see the result.
Column = CALCULATE(SUM(Table1[Volume]),FILTER('Table1','Table1'[ID]=EARLIER(Table1[ID])&&'Table1'[Ciyt]=EARLIER(Table1[Ciyt])))
You can also download the PBIX file to have a view.
https://www.dropbox.com/s/ciybodnwcinfxnw/calculated%20column%20by%20column%20ID1.pbix?dl=0
Regards,
Daniel He