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.
I'm trying to get to..
I am trying to create a Treu/False column with this logic
If [Is Target] is true then True
or else if
If [AccountTypeGroup] =Client then True
or else if
[AnnualRevenue] >= 250000000 and [Has Products] = "True" and [Marketing Country] = "True" then True
else False
I dont think my syntax is right
if [AccountTypeGroup] = "Client" then true else if [Is Target] = "True" then true else if [AnnualRevenue] >= 250000000 and [Has Products] = "True" and [Marketing Country] = "True" then true else false
Solved! Go to Solution.
Hi @OleMcDonald
Download an example PBIX file with the below code in it.
If you could supply your actual data it would help becaue it's not clear if your true/false values are Boolean true/false or if you are using text strings.
If you are using Boolean True/False then your data would look like this
and you would use this query to create a Custom Column
if [AccountTypeGroup] = "Client" or [Is Target] = true
then true
else if [AnnualRevenue] >= 250000000 and [Has Products] = true and [Marketing Country] = true
then true
else false
If you are using text columns for True/False you're data will look something like this (notice the icons in the column headers are different for True/False compared to the Boolean columns above)
Using text adds another complication in that the text string True is not the same as the text string true, but you could use a query like this
if [AccountTypeGroup] = "Client" or [Is Target] = "True"
then true
else if [AnnualRevenue] >= 250000000 and [Has Products] = "True" and [Marketing Country] = "True"
then true
else false
Regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
All of your replies were extermely helpful. Thank you all for taking the time to help.
I didnt know "True" and true were not the same. So, I went back and edited the columns I created to true / false rather than "True" / "False".
Thanks again
Hi @OleMcDonald
Download an example PBIX file with the below code in it.
If you could supply your actual data it would help becaue it's not clear if your true/false values are Boolean true/false or if you are using text strings.
If you are using Boolean True/False then your data would look like this
and you would use this query to create a Custom Column
if [AccountTypeGroup] = "Client" or [Is Target] = true
then true
else if [AnnualRevenue] >= 250000000 and [Has Products] = true and [Marketing Country] = true
then true
else false
If you are using text columns for True/False you're data will look something like this (notice the icons in the column headers are different for True/False compared to the Boolean columns above)
Using text adds another complication in that the text string True is not the same as the text string true, but you could use a query like this
if [AccountTypeGroup] = "Client" or [Is Target] = "True"
then true
else if [AnnualRevenue] >= 250000000 and [Has Products] = "True" and [Marketing Country] = "True"
then true
else false
Regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
Hi,
Remove the "" from around the true. Also, Mashup ("M") - the language of the Query Editor is case sensitive. So ensure that case of true matches with the case of true in the 3 columns.
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 |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |