Monthly Revenue

[AlexIsac16]

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

 

[Tahreem24 · Accepted solution]

@AlexIsac16  Try this DAX:

Measure = CALCULATE(SUM('Table'[Revenue]),ALLEXCEPT('Table','Table'[Month]))

[AlexIsac16]

Hi Tahreem,

Had to add some extra steps to your formula but eventually it worked! Thanks!

Alex