Forum Discussion

BIswajit_Das's avatar
BIswajit_Das
Icon for Impactful Individual rankImpactful Individual
2 years ago
Solved

Calculated Table

Hello Experts, Need Guidance with the below structure Table1 with data : id party value 1 B 10845 2 B 22921 1 I 20921 5 I 5807 7 I 40044 9 B 24634 9 I 11967...
Need Help
Tips and Tricks
  • sjoerdvn's avatar
    sjoerdvn
    2 years ago

    I don't think it is possible to do a pivot operation dynamically in dax; only in power query. At least I can not think of any way to achieve this.

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi BIswajit_Das 

     

    sjoerdvn is right.

    DAX has a number of limitations, and if this is a calculated table, this is the only way to do it

    Or you can try to export the data from the calculated table and import it again to use power query. But it's going to be very complicated.

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

BIswajit_Das's avatar
BIswajit_Das
Icon for Impactful Individual rankImpactful Individual
2 years ago

Hello Anonymous, Idrissshatila 

Thanks for responses but as I mentioned above my table is a calculated table which is not gonna show in transform data section
That's why I wonder if there's another way to do so..
Thanks & Regards...