Forum Discussion
Evanooruvan
Helper II
3 years agoCreate 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
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
- amitchandak
Super User
In dAX new column
DS1= if([Serial Number] ='DS1', [Percent], blank())
DS2= if([Serial Number] ='DS2', [Percent], blank())
Direct query only support simple column