Forum Discussion
Cannot create a Time Intelligence Measure in the Warehouse
Hi Luci7 ,
We have an update from internal team.
If the two datasets have a different structure, its okay for the syntax to be different.
In Power BI Desktop, a valid measure expression could read:
DAXCopy
Date Count = COUNT(Sales[OrderDate].[Date])Note:
While this measure expression is valid in Power BI Desktop, it's not correct DAX syntax. Internally, Power BI Desktop transposes your expression to reference the true (hidden) auto date/time table column.
Hope this is helpful.
Hi Luci7 ,
We have an update from internal team.
If the two datasets have a different structure, its okay for the syntax to be different.
In Power BI Desktop, a valid measure expression could read:
DAXCopy
Date Count = COUNT(Sales[OrderDate].[Date])Note:
While this measure expression is valid in Power BI Desktop, it's not correct DAX syntax. Internally, Power BI Desktop transposes your expression to reference the true (hidden) auto date/time table column.
Hope this is helpful.
Hi Anonymous ,
I see!! This is why! In Power BI Desktop we have the "auto date/time table" but not in Fabric, hence, the date column is not automatically converted to show date hierarchy.
Thank you for the clarification!! That helps a lot.
Have a nice day!
Kind regards.
Hi Luci7 ,
Glad to know your issue got resolved.
Please continue using Fabric Community for help regarding your issues.