Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear All,
I am from Tableau background and not so good in DAX expressions,
Below is my sample table format , Where I need to copy the values of Column Value to Column
A value where the Application Column is "A" .
I tried it in Edit Query and creating custom column but unable to get the result based on condition
Can any one please help me how can I make it
Solved! Go to Solution.
You can achieve with the help of 'Conditional Column' in the 'Add Column' ribbon in the Query Editor
Select Column in the Output showned in the below image
Nandri
You can achieve with the help of 'Conditional Column' in the 'Add Column' ribbon in the Query Editor
Select Column in the Output showned in the below image
Nandri
You can use this code in the custom column:
if [Application] = "A" then [Value] else null
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |