Forum Discussion
Creating a table for daily plan vs. actual data
Hi! I'm working at a manufacturing company and I'm new to Power BI. I'm trying to create a dashboard containing a simple table and need some help. My raw data in Excel spreadsheet looks like bel...
Hi, Anonymous
You can try the following methods. Choose Date column then unpivot Other Columns:
Result:
Select the second column-Split Column:
Result:
Save and apply to Desktop.
Is this the result you expected?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MattAllington
Community Champion
Community ChampionHints:
- do not change your source data (unless there is some other reason to do so)
- investigate Power Query unpivot against your raw data.
- This will transpose your raw data into the shape you need (a table containing date, machine, attribute (ie plan or actual), amount)
- don't load the delta column from your raw data. Calculate it using dax
- Use a matrix to visualise your data
Thank you for the tips! I will definetely start learning Power BI.