Forum Discussion

mdomin35's avatar
mdomin35
New Member
2 years ago
Solved

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 acc...
Tips and Tricks
  • fahadqadir3's avatar
    fahadqadir3
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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