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, ...
  • amitchandak's avatar
    3 years ago

    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