Forum Discussion

BIswajit_Das's avatar
BIswajit_Das
Impactful 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
Impactful Individual
2 years ago

Hello sjoerdvn 
Thanks for responding
Yeah we can do it this way
But we  have mention column names each time
Isn't there any other way to acheive this?

Anonymous's avatar
Anonymous
Not applicable
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.