Forum Discussion
Powerbi Column help
I am trying to Sum the value of AC by each date, and filter with 2 Accounts (AN) labeled as 8000 & 2500, how would I do that?
Like for date 12-29-2022, I want to have the sum of AC by both account number 8000 and by account number 2500
Example: on date 12-29-2022 AC=1,000,000 for AN 8000, and AC=2,000,000 for AN 2500
mdomin35 Review the following screenshot and Measure to Calculate Total:
Total SUM of 2500&8000 =
CALCULATE(
SUM('Table'[AC]),
'Table'[AN] IN {8000, 2500}
)Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
2 Replies
mdomin35 Review the following screenshot and Measure to Calculate Total:
Total SUM of 2500&8000 =
CALCULATE(
SUM('Table'[AC]),
'Table'[AN] IN {8000, 2500}
)Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.Your solutions is great fahadqadir3
Hi, mdomin35
Have you already solved the current problem? If yes, you can share your solution here or mark your helpful reply as a solution so that other members of the community can quickly find a solution if they encounter the same problem. Thank you very much for your cooperation.
Best Regards
Jianpeng Li
