Forum Discussion
1 data set, 20 odd fixed columns, 9 dynamic columns
Hi, ** Apologies in advance for the bulk of text - not sure how to summarise this in to a short question! I am working with healthcare data, trying to build a data quality dashboard that show...
MattAllington
Community Champion
Community ChampionYou should consider unpivoting the data from columns into rows using power query during load to power BI. That is a much better data structure