Grouping data within single date columns

[McRobot]

Im having a bit of struggle trying to group the layout of this data.

My goal is to group all date columns into a single date column.

This would then allow me to use a slicer to filter the data columns by date.

Not the strongest at DAX, but if anyone could suggest an effective way of doing this (either before loading into or once in Power BI) then I'd really appreciate the guidance.

[RobbeVL · Accepted solution]

Hi There,

To fix this, you wont be needing any DAX.
You can quite easily fix this problem in PowerQuery with "Unpivot"

I've added a PBIX file where I show you how to do this.

https://drive.google.com/file/d/140ddl6QV-R63_lnxXRvtiFauup8BMywT/view?usp=sharing 

Robbe