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 ) ,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"

 

 

5 Replies

  • ValtteriN's avatar
    ValtteriN
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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/

      • ValtteriN's avatar
        ValtteriN
        Icon for Community Champion rankCommunity Champion
        4 years ago

        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?

  • 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.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.