Forum Discussion
Enhanced DAX Time Intelligence not working
Morning All,
Appreciating that that "Enhanced DAX Time Intelligence" is in preview mode, but I am struggling with the basic setup. I have enabled the ability, rebooted Power BI and I have the calander option. If I add a new calander based from my current calander, it appears a seperate calander in the calander option list, but it does not appear on the right hand side in any table and thus I can not access it.
What am I missing? Thx
Hello BugmanJ , yes if you are talking about model view it is visible in my case too:
It is not visible under Data page as shown below but I am able to use it in the calculation:
4 Replies
Hi BugmanJ ,
I tried to replicate what you mentioned, and it looks like this is expected behavior.
The new calendars don’t appear as normal tables in the Fields list, but they can still be referenced in DAX calculations (for example, when creating measures). If you need to use a date table directly in visuals, you’ll still have to create a physical date table in Power Query or DAX.
You can refer to the documentation below for more details.
http://sqlbi.com/articles/introducing-calendar-based-time-intelligence-in-dax/But according to MS visuals and documentation, you should be able to see it in the visual tables?
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-time-intelligenceHello BugmanJ , yes if you are talking about model view it is visible in my case too:
It is not visible under Data page as shown below but I am able to use it in the calculation:
