Create two column based on two other column

[Evanooruvan]

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

[amitchandak · Accepted solution]

@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