Forum Discussion
Sum by Month Help
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!
I tried:
Sum Pay1 by month = CALCULATE([Pay1], ALLEXCEPT('Table', 'Table'[SignedDate]))
The output is:
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!