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.
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/