Forum Discussion

Waseem_Abbas's avatar
Waseem_Abbas
Regular Visitor
3 years ago

Comulative sales measure problem

I want to create a measure as under   Cumulative Sales 2023 = VAR CurrentYear = YEAR(MAX('Date Table'[Date])) VAR CurrentMonth = MONTH(MAX('Date Table'[Date])) VAR CurrentDate = DAY(MAX('Date Table...
General Comment
devesh_gupta's avatar
devesh_gupta
Icon for Impactful Individual rankImpactful Individual
3 years ago

Waseem_Abbas Please make sure that you've marked your table as a date table. To do so, right-click the table's name in the Fields pane and select Mark as date table. Power BI verifies the data in the table by marking it as a date table, ensuring that the date column is of data type Date and contains unique values.

If you find this insightful, please provide a Kudo and accept this as a solution.