Forum Discussion
Solved
Monthly Revenue
Hi all, Trying to create a calculated column that gives me the total revenue for that specific month, based on the value in the Ship Date column. So for instance, the total revenue for January sh...
AlexIsac16 Try this DAX:
Measure = CALCULATE(SUM('Table'[Revenue]),ALLEXCEPT('Table','Table'[Month]))
AlexIsac16 Try this DAX:
Measure = CALCULATE(SUM('Table'[Revenue]),ALLEXCEPT('Table','Table'[Month]))
Hi Tahreem,
Had to add some extra steps to your formula but eventually it worked! Thanks!
Alex