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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi BIswajit_Das 

 

 

Please try this:

Click the Transform data in the Home pane:

Copy the origin table and paste it:

      

Select the party column and click the Pivot Column:

The result is as follow:

Finally, Close & Apply.

 

 

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.