Loading Files With Varying Schema in Power BI using Power Query
Unpivoting in PowerQuery is easy, but what if you don’t know how many columns you have to unpivot?
Dates
Finding the Oldest Latest Date
Understanding the requirement is often harder than the final solution.
Filtering Date Dimensions in Power Query
Power Query shenanigans, but does it fold?