Forum Discussion

xDaniellaM's avatar
xDaniellaM
Regular Visitor
3 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

Idrissshatila's avatar
Idrissshatila
Super User
3 years ago

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-dax

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

xDaniellaM's avatar
xDaniellaM
Regular Visitor
3 years ago

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?