Working with Slowly Changing Dimensions in Power BI

Do you have slowly changing dimensions in your Power BI dataset? Struggling to work with them to get the right values? Patrick walks you through how you can deal with them. Download sample files: http://guyinacu.be/scdsample Wikipedia https://en.wikipedia.org/wiki/Slowly_changing_dimension Using calculation groups to switch between different dates (SQLBI) https://www.youtube.com/watch?v=kilQrRR04mY P3 - https://powerpivotpro.com/2019/06/how-can-i-get-a-lookup-table-from-a-slowly-changing-dimension-scd/ 📢 Become a member: https://guyinacu.be/membership ******************* Want to take your Power BI skills to the next level? We have training courses available to help you with your journey. 🎓 Guy in a Cube courses: https://guyinacu.be/courses ******************* LET'S CONNECT! ******************* -- http://twitter.com/guyinacube -- http://twitter.com/awsaxton -- http://twitter.com/patrickdba -- http://www.facebook.com/guyinacube -- https://www.instagram.com/guyinacube/ -- https://guyinacube.com ***Gear*** 🛠 Check out my Tools page - https://guyinacube.com/tools/ #PowerBI #SCD #GuyInACube