Date table functionality needed in DirectLake Semantic model
When building a Semantic model in the Service or in Desktop with tables from DirectLake to a Lakehouse the table of calendar dates acts like a fact or dimension table and not a date table. Also, fields with Date data type do not get recognized in Semantic model with the date hierarchy for time intelligence visualization or aggregations. The Semantic model requires me to switch to DirectQuery mode to add a date table that works for time intelligence features. This is a major disappointment that a basic concept in model building is restricted. I worked out enough DAX to get around it temporarily only to find that I also cannot sort a column in a table by another column in a table, which is also a standard tool in Power BI Desktop.
Please consider at bare minimum a date table option for time intelligence visuals and measures.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Data Pipelines - Run only selected activities
For debugging and testing pipeline activities during development, allow us to select one or multiple activities and run only the selected pipeline activities. For example, I'm working on editing ...frithjof_v6 hours agoCommunity ChampionNew612Views11likes2CommentsSemantic model connection bindings should be in source control (Git)
Semantic model data source connection bindings should be source controlled. A semantic model can contain multiple data source references, each of which can be mapped to a separate Fabric data connec...frithjof_v14 hours agoCommunity ChampionNew17Views1like0CommentsBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal14019717 hours agoFrequent VisitorNew6Views0likes0Comments