Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

YTD QTD MTD doesn't work

I am playing around with the provided tutorial example, "financial", and tried to learn different functions. I didn't modify any data they provided, but only added a DateTime table and connected it w...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    I think I got the answer accidentally. The reason I got empty cell are due to wrong data selection, I chose the "Month" from the fact table "financial", instead of choosing the "Month" from the dim table/calendar.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Not sure if this is the problem but the time intelligence functions need to have full years to work correctly. Try using CALENDARAUTO instead of CALENDAR, or use

CALENDAR( DATE( MIN(YEAR(financials[Date])), 1, 1), DATE( MAX(YEAR(financials[Date])), 12, 31)
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks johnt75, I have tried both methods and looked back to the matrix, but neither shows the result.