Forum Discussion

Evanooruvan's avatar
Evanooruvan
Icon for Helper II rankHelper II
3 years ago
Solved

Create two column based on two other column

I have two columns named serial number and percent, i want to create two columns, where one column will contains percent of DS01 and other column will contain percent of DS02,
Need to do it in dax, because it is Direct query cant use Power query.

Thanks

 

 

amitchandak

  • Evanooruvan ,

    In dAX new column

     

    DS1= if([Serial Number] ='DS1', [Percent], blank())

     

     

     

    DS2= if([Serial Number] ='DS2', [Percent], blank())

     

     

    Direct query only support simple column

1 Reply

  • Evanooruvan ,

    In dAX new column

     

    DS1= if([Serial Number] ='DS1', [Percent], blank())

     

     

     

    DS2= if([Serial Number] ='DS2', [Percent], blank())

     

     

    Direct query only support simple column