Relationship Issues With DateTime Data Types in Power BI
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 -- https://endjin.com/blog/2020/03/power...
BECOME A CHANNEL MEMBER 🎉
-- / @havensconsulting
LET'S CONNECT! 🧑🏽🤝🧑🏽 🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
VIDEO CHAPTERS 🎥
0:00 - Start of Video
0:40 - Start of Demo
2:55 - Power Query Vs. DAX Data Types Blog
HAVENS CONSULTING PAGES 📄
Home Page - http://www.havensconsulting.net
Blog -- http://www.havensconsulting.net/blog-...
Blog Files -- http://www.havensconsulting.net/blog-...
Files & Templates -- http://www.havensconsulting.net/files...
Consulting Services -- http://www.havensconsulting.net/consu...
Online Courses -- https://www.havensconsulting.net/onli...
Contact & Support - http://www.havensconsulting.net/conta...
EMAIL US AT 📧
[email protected]
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #powerquery #dax #datatypes #datamodeling #powerquery #dax