Forum Discussion
Columns to Rows Data Modelling Challenge
Hi - I think I'm close but stuck on final hurdle. I have used a combination of UnPivot, and Re-Pivot to get me there. I have a data set that looks like this (3 related fields for Product, Unit P...
Anonymous
Attaching your Excel file as well. Please see the steps from Query Editor
Zubair_Muhammad - thats very very clever - especially the first custom field.... thank you so much. Would never have gotten that far on my own.
QQ - Will there be any issues refreshing this dataset in Power BI?
Thanks,
Gerard
Anonymous
Hopefully no issues. But let me know if it gives error
Zubair_Muhammad - Just to confirm, I have adapted this solution to my specific use case and it is working very well... there are also no issues with refreshes.
Thank you so much for your help!
Regards
Gerard