Forum Discussion
Table structure
Hi, I'm working with data that will have about 10 million rows per day. Currently, the rows are nested which is something Power BI can't handle. The question that arises is the structure of the tabl...
Anonymous , the second one is ideal for you need but if you have 10 Million per day. Unpivot of this data will take huge time and may not work.
In that case if you have limited columns you can try like
divide(sum(Table[ColumnA]), sum(Table[ColumnA])+sum(Table[ColumnB])+sum(Table[ColumnC])+sum(Table[ColumnD])+sum(Table[ColumnE]))