Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |