If Condition

[SIBI1998]

Hi Team,

                 I want an if Condition for this Query :

If the Derative Count is greater than gaurav Patel Target (Example :  Derative Count is 100 , gaurav Patel Target is 70 ) ,Here I need 100-70=30 and 30 is multipled by 50 and then

If the Derative Count is less than gaurav Patel Target value is to be "0"

[v-yalanwu-msft]

Hi， @SIBI1998

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we could close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,

Community Support Team_ Yalan Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @SIBI1998 ;

You could try it.

value=
IF ( [Derative Count] >= [Patel Target], [Derative Count] - [Patel Target], 0 )

If this doesn't fit your data model, can you share more information about your requirements? For example, are your [Derative Count] and [Patel Target] columns or measures? It is best to share a simple file.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ValtteriN]

Hi,

Try something like this:
//if Derative Count and  gaurav Patel Target are measures use them in place of variables

var DC = MAX(Table[Derative Count])
var GPT = MAX(Table[gaurav Patel Target]) return
IF(DC>GPT,(DC-GPT)*50,0)

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[SIBI1998]

@ValtteriN 

Given Solution is not working with in this case

[ValtteriN]

There was a ) missing:

//if Derative Count and  gaurav Patel Target are measures use them in place of variables

var DC = MAX(Table[Derative Count])
var GPT = MAX(Table[gaurav Patel Target]) return
IF(DC>GPT,(DC-GPT)*50,0)

What kind of error are you getting?