Forum Discussion

SIBI1998's avatar
SIBI1998
Icon for Helper I rankHelper I
4 years ago

If 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...
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

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.