IF function

[Kalindi_2021]

Hi Team !

Greetings of the day !

Please guide Why does IF function not work in POWER BI when applied to return the value "good" for big profit .

Is there any limitations of 'IF' for string or integer.

Thanks

[TomMartens · Accepted solution]

Hey @Kalindi_2021 ,

from my experience I can tell that IF works with Power BI.
Based on the scarce information you provided it's not possible to provide any help.
Provide the statement, tell us if you are using DAX and want to create a calculated column or a measure or if you are going to us Power Query and use M.

For now, I recommend reading this: IF – DAX Guide

Hopefully, the article helps to tackley your challenge.

Regards,

Tom

[Kalindi_2021]

 TomMarten !
I want to add a calculated column for the sum of profit in which values must be executed as per "good profit" and "average profit".

Category Sum of Profit
Furniture 18,451.27
Office Supplies 1,22,490.80
Technology 1,45,454.95

Here the category "Technology" must come with "GOOD PROFIT", but it is not working.
Thanks