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 should be around 99,000 but the value in the cell always gives me the same value in the revenue column.
Would anyone be able to tell me how the formula should be structured?
Thanks,
Alex
AlexIsac16 Try this DAX:
Measure = CALCULATE(SUM('Table'[Revenue]),ALLEXCEPT('Table','Table'[Month]))
2 Replies
Tahreem24Super User
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
