Forum Discussion

eric_005's avatar
eric_005
Frequent Visitor
1 year ago
Solved

Calendar table power query does not return correct values using DAX TOTALYTD function

Hi there, I’m quite new to Power BI. My data source is DirectQuery to Analysis Services (AS). I’ve been advised by our BI developer to create my calendar in Power Query instead of using a calculated ...
Need Help
  • eric_005's avatar
    eric_005
    1 year ago

    ToddChitt Sorry Todd, I've been advised by our IT not to proceed on this due to confidentiality. But my issue has been resolved by one of the developer. thanks heaps for your help 🙂

ToddChitt's avatar
ToddChitt
Super User
1 year ago

What is the granularity of the Calendar table? Is it Year and Month, or is it by day? Can you show some sample data?

And what is the date granularity of the fact table? Also by Year and Month?

Can you show us some sample Date data from both tables?