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
1 ACCEPTED SOLUTION
@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]))
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
