Forum Discussion
create a table from a power bi dataset
Hi, I'm still a novice and have an issue which is difficualt to explain I have a data set for my work that gives me reasons why people are leaving the business I work for. Te way to data is pres...
I can see what your thinking.... it would require pulling the data twice. though,... the are over 40 columns of data in the table (I only refered to the 14 in my prvious message). So i wouldn't want to unpivot it all. I'd have to do a second data pull of only those 14 columns and then unpivot.... kinda wanting to avoid that
Seward12533
Solution Sage
Solution SageWhy not? PowerBI is incredibly efficient at tall narrow tables with limited number of distinct values. I saw a demo at a recent power bi summit where expert showed significant performance improvement by doing something similar. Trying to deal with columnar delimited data like this goes against the grain of how PowerBI works and will make your life and Dax very complicated and your workbook slow.
I dont want to unpivot the whole data table. thre are many columns. The first column being a timedate stamp. and the data is growing so not practical to unpivot the whole daya table
- Seward12533Up to you it’s the right way. Whole counter intuitive it’s the best way handle it. Otherwise you will probably need to write a measure to calculate each of the columns individually. Could be impractical if your adding new reasons.