Forum Discussion
Reformatting messy data
Stop me if you've heard this one... I've received an Excel spreadsheet from a user who wants to know if their data can be visualized in Power BI. The structure is set up for data entry rather than a...
I think I get what you're trying to get to.
Have a look at the attached PBIX and let me know if you have any questions.
(apologies, it's a little rushed so I haven't renamed the steps or tidied up any of the code)
I think I get what you're trying to get to.
Have a look at the attached PBIX and let me know if you have any questions.
(apologies, it's a little rushed so I haven't renamed the steps or tidied up any of the code)
Wow! It does just what I need. I'll need to study this a while to understand how you decomposed and recomposed the original table. Amazing.
Thank you so much!