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.
How to add 'and' under 'add conditional column'?
if 'target' is great than 2 and *****, then ***
Solved! Go to Solution.
Hi @Anonymous
In order to do that you will need to add a Custom Column
The syntax is the following below and NOTE that it is case sensitive
if [Target] > 2 and [Other column] = "Closed" then "My Output Closed" else if [Target] > 1 and [Other column] = "Open" then "My Output Open" else "Other Output"
Hi @Anonymous
In order to do that you will need to add a Custom Column
The syntax is the following below and NOTE that it is case sensitive
if [Target] > 2 and [Other column] = "Closed" then "My Output Closed" else if [Target] > 1 and [Other column] = "Open" then "My Output Open" else "Other Output"
@GilbertQ thanks, but i don't really get it. how do i add 'and' in the picture i attached? see above.
@GilbertQ yes, i'm in edit queries/add column/conditional column. but where to add 'and'
for example below, how should i say
if actualstart = 11/07/2017 and (or) ****, then output = 13/07/2017.
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |