Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Dear community
I have multiple CSV blobs in a particular storage container. Those are pulled from our backup system once a week for the last seven days. Each row indicates the system to be backed up, and then n-amount of date-named columns show if the backup was successful on this particular date (1) or not (0).
I need to be able to use date slicers in my dashboard and provide an easy overview. Therefore, i need one row per system per date for the dynamic amount of dates (columns) like this:
I now tried 3 hours, and need to give up. How can i do this conversion in the easiest way?
Thank you very much for any help!
Solved! Go to Solution.
Hi there.
Have you tried in Power Query selecting all the columns except the System Column and then using the "Unpivot Columns" function?
Doing that should give you an output like this:
Then you'd just need to rename the 2 columns it created and you should be good to go.
Thank you very much, it worked perfectly!
Hi there.
Have you tried in Power Query selecting all the columns except the System Column and then using the "Unpivot Columns" function?
Doing that should give you an output like this:
Then you'd just need to rename the 2 columns it created and you should be good to go.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.