Forum Discussion
SIBI1998
Helper I
Helper IIf Condition
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 ) ,He...
ValtteriN
Community Champion
Community ChampionHi,
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/
- 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?