Forum Discussion
Creating of model table in PowerPivot
Hi everyone! There is my case: I have few data tables in PowerPivot with similar types of data. In these tables I created couple calculated column and it work correct. For creating of pivot tables...
az38 ,
Unfortunately, SELECTCOLUMNS() doesn't work too. How I known from another BI-forum, its impossible to create calculated tables in PowerPivot, so single solution - clear data just in PowerQuery (although in this case it would be more convenient in PowerPivot).
jeremyking77 , no, its not about uppercase/lowercase - I tried to do the same with just one table with small amount of data (about 10 lines), its doesn't work too.
Nonetheless, thanks for help!
jeremyking77
Helper I
Helper INorthLegion is it possible for you to attach the pbix file? or is it sensitive information?