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