I find I do love a good challenge and I find that I get them frequently. I also enjoy sharing what I have learnt with others.
In this blog post I am going to show you how I found a way to create Dynamic Date Column Headers for Tables or Matrixes in Power BI.
Below is what it looks like once completed. What I did was to create a matrix with the last 5 Days (Showing each date for the last 5 days) and then along with this an MTD calculation which shows not only the header of MTD but it includes the current months values.
This is an interesting one for sure. Read on to see how Gilbert solved the problem.