Forum Discussion
dcadwallader
Helper I
Helper IMass Data Editing Query/Data Modelling
Afternoon, So, I have a Power BI report linked to an excel file. This excel file charts performance statistics for various stakeholders across different metrics (inspected, passed, pass rate ...
GilbertQ
Super User
Super UserHi dcadwallader,
I am unsure exactly of your data structure, but if you had to Unpivot the data, would you then not go from 1590 columns to possibly 3 - 4 columns?
And then you could simply update it from there?
dcadwalladerHelper I
Helper IHi GilbertQ
Would love that to be the case but the table isnt pivoted.
It's simply that wide.
Cheers for getting back though.