Posts filed under Data Modeling

Relationship Issues With DateTime Data Types in Power BI

Video by: Reid Havens

Learn about a potential pain point when it comes to dealing with DateTime data in a fact table. You can potentially encounter an issue when joining your fact to a calendar table. Specifically if you import a Fact table into your model with a datetime column, and convert that column to a date data type in the model, instead of in Power Query. If you do this then that relationship still won't work until you make that change in Power Query.

RELATED CONTENT 🔗

PQ Vs. DAX Data Types

Posted on April 13, 2021 and filed under Power BI, Beginner, Data Modeling, Power Query.

(Livestream Replay) DAX Modeling Best Practices with Marco Russo

Hang out with us as Marco Russo and I go through DAX and modeling best practices related to: relationships, bi-directional filtering, and more! The livestream will be split into sections for a lively discussion on the topic, demo, and time for Q&A at the end.

RELATED CONTENT 🔗

SQLBI Website
Marco's Twitter
Syncing Slicers in Power BI

Showing DAX Expressions When Using Power BI Datasets (Live)

Video by: Reid Havens

Learn how to display DAX expressions in the description tooltip - when hovering over the measure in the fields list. This can be applied to all measures easily and effortlessly using Tabular Editor.

Related Content

External Tool - Tabular Editor

External Tool - DAX Studio

Code Snippet

foreach (var m in Model.AllMeasures) { m.Description = m.Expression; }