Sum by Month Help

[Brite]

Hello,

I have been trying to sum Pay1, Pay2, and Pay3... data by the same month. What is the best way to solve this? Thanks!

[PaulDBrown]

try:

Sum Pay1 = CALCULATE (SUM(Table[Pay1]), ALLEXCEPT(Table, Table[SignedDate]))

etc...

[Brite]

@PaulDBrown Forgot to mention Pay1, Pay2, Pay3... are all measures. The Dax formula above doesn't accept sum('Tablename'[Pay1]). How would I sum Dax measures (Pay1, Pay2, Pay3..)? 

[PaulDBrown]

It depends on what the measures calculate, but in  principle:

Sum Pay1 by month= CALCULATE [Pay1],  ALLEXCEPT(Table, Table[SignedDate]))

or

SUMX(ALLEXCEPT(Table, Table[SignedDate]), [Pay1]))

[Brite]

I tried:

Sum Pay1 by month = CALCULATE([Pay1], ALLEXCEPT('Table', 'Table'[SignedDate]))

The output is:

[v-kelly-msft]

Hi @Brite ,

Could you pls share your .pbix file for test?

Remember to remove the confidential information.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[PaulDBrown]

You need to replace 'Table' in the expression to your actual table name!