Forum Discussion
TotalYTD in a Matrix
Hi Anonymous,
The hierarchy should be in your original table rather than the calendar table,check my sample below:(remember to create a relationship between the 2 tables)
Check my .pbix file attached.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Community ChampionHi Anonymous
I think your issue is more like using Time intelligence function without a Calendar table. if you have gaps in your 'Sales Data'[Day].[Date] then don't count on TOTALYTD to outcome an accurate result.
Thank you for the reply!
I created the calendar table, but I am still having the same issue as before where it just repeats the last sales data from May 3rd 2021. I want to be able to drill down through a date hierarchy. In the dax code what would that look like as I am unsure of how to link it to a hierarchy within the calendar table. I have the calendar hierarchy broken down between 'CalendarYear' 'CalendarQuarter' 'CalendarMonth' 'CalendarDate'.
The DAX I am currently using is as follows:
Year to Date = TOTALYTD(SUM('Sales Data'[Net Sales]),'Calendar Table'[CalendarDate])
Thanks again!
v-kelly-msftCommunity Support
Hi Anonymous,
The hierarchy should be in your original table rather than the calendar table,check my sample below:(remember to create a relationship between the 2 tables)
Check my .pbix file attached.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!