Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
BugmanJ
Helper V
Helper V

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

1 ACCEPTED SOLUTION

Hello @BugmanJ , yes if you are talking about model view it is visible in my case too: 

AnkitaaMishra_0-1758620230425.png

It is not visible under Data page as shown below but I am able to use it in the calculation:

AnkitaaMishra_1-1758620293630.png

 

 

View solution in original post

4 REPLIES 4
AnkitaaMishra
Super User
Super User

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: 

AnkitaaMishra_0-1758620230425.png

It is not visible under Data page as shown below but I am able to use it in the calculation:

AnkitaaMishra_1-1758620293630.png

 

 

Not realised it was in a model view only (seems a bit dumb IMHO). Thank you though!

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.