Forum Discussion
Help with Writing Different IF Statements
Hi all,
I'm new to PowerBI and have to write a few IF statements for an assessment I'm doing.
1. I need to write an IF statement to determine if a column called 'Cost' has any negative values (<0). Or, if Value<0 is true.
2. I need to write another IF statement for a column called 'Profit' to determine if its values are less than those of a column called 'Revenue'. Or, If Profit<Revenue is true.
3. Lastly, I need an IF statement to determine if the values in a column called 'Discount' are less than or equal to 1 (<=).
I'd appreciate any help.
Hi xDaniellaM ,
You just need to make a simple modification based on Idrissshatila formula, please try below dax formula:
3- CostIF = IF ( 'YourTableName'[Discount] <= 1 && 'YourTableName'[Discount] > 0, "True" )Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hello xDaniellaM ,
1- CostIF =
IF(
'YourTableName'[Cost] < 0,
"True"
)2-
1- ProfitIF =
IF(
'YourTableName'[Profit] <'YourTableName'[Revenue],
"True"
)3- CostIF =
IF(
'YourTableName'[Discount] <= 1,
"True"
)
you could also learn about if statement through this microsoft documentation https://learn.microsoft.com/en-us/dax/if-function-daxIf I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Thank you for your response.
For the third (the Discount), how can I include an AND statement to determine that all values in the column are >0 and <=1?
Hi xDaniellaM ,
You just need to make a simple modification based on Idrissshatila formula, please try below dax formula:
3- CostIF = IF ( 'YourTableName'[Discount] <= 1 && 'YourTableName'[Discount] > 0, "True" )Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
