Forum Discussion
Luci7
Helper I
3 years agoCannot create a Time Intelligence Measure in the Warehouse
Hey everyone, Good day! I've run into a weird scenario. In Power BI Desktop, I was able to create quick measures, especially the time intelligence ones. But the moment I throw the DAX into the...
- Anonymous2 years ago
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.