Forum Discussion

Glenda's avatar
Glenda
Icon for Helper I rankHelper I
8 years ago
Solved

Using Greater than in a IF foumla

I am trying to set up a new column where 2 things must be met. One is the state and the other is depending on date. The standard formula i use in excel is not working.    Policy = IF (AND('XOX Repo...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Dear Glenda

        Try this:

    Policy = IF( and(  value( W_DAY_D[Year]) = 2017,  value(FORMAT( W_DAY_D[Date], "YYYYMMDD")) < 20170901 ) ,"my True", "my False")

     

    My result

Anonymous's avatar
Anonymous
Not applicable
8 years ago

GlendaYou are welcome.

 

Can you post your script here (your last comment).

Maybe I'll help your case and your expectation.

 

Regards.

v-kegros's avatar
v-kegros
New Member
8 years ago

Hello all,

 

I am having troubles implementing this formala in one of my BI:

 

Badge Completion Status = if('Badges table'[Badges]="Bronze",IF([Badge count]>=3,"Complete","Not Complete"),IF('Badges table'[Badges]="Silver",IF([Badge count]>=2,"Complete","Not Complete"),IF('Badges table'[Badges]="Gold",IF([Badge count]>=4,"Complete","Not Complete"))))

 

It seems to work perfectly in Excel, but not in BI.

Short explanation: i want to show completion status based on number of badges received. If greater or equal than x, then show completed. Can you please help me? See below screen shot which shows incorrect results...

thanks in advance

Kevin