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

Видео Working with Slowly Changing Dimensions in Power BI канала Guy in a Cube