Year to Date

[Anonymous]

Hi,

I am trying to do a 'year to date'  but my card is only showing 396.00 which is very wrong, my DAX is .

It should be a lot more does the DAX look ok?

yTD = TotalYTD(sum(adDetails[Revenue]), calender[Date], All(calender))

[Seth_C_Bauer · Accepted solution]

@Anonymous Do you have a filter or slicer applied that would alter the total on the report page?

[kcantor · Accepted solution]

I believe you are hitting a glitch with the inclusion of the ALL function. YOu should specify a year end date with the YTD calculation if you have a custom calendar. For exampl if my fiscal year ended on June 30th I would use:

TOTALYTD([TotalRevenue], Calendar[Date], 6/30)

I would build the [Total Revenue calculation instead of calculating it within the other measure just to make sure that if a measure broke it would be easy to troubleshoot.

TotalRevenue = SUM(adDetails[Revenue])

If I did not need the fiscal year to be defined I would leave it out.

tOTALYTD([TotalRevenue], Calendar[Date])

[Anonymous]

Sorted!

[Seth_C_Bauer · Accepted solution]

@Anonymous Do you have a filter or slicer applied that would alter the total on the report page?