Forum Discussion
Enhanced DAX Time Intelligence not working
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:
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-intelligence
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:
Not realised it was in a model view only (seems a bit dumb IMHO). Thank you though!