DAX : If then else...

[StevieCho]

I'm sorry, I'm coming here with what must be a very stupid question. I am still a newcomer to PowerBI.

The following facts:

First Test (IF) :
Are the hours equal to or above 13
If NO : Give the hours entered
If YES :
Second test (IF) :
If the field has a trigger (=1), If YES :
Give the entered hours, if NO : Write 13

Since there is probably no If then else in the DAX, it is...at least for me, a bit more complicated. 

Thanks in advanced 🙂

[StevieCho]

Thank you Guys, i'll ty it later 🙂

[Idrissshatila · Accepted solution]

Hello @StevieCho,

you need to fill the hours column and the triger column in the measure:

Column = if( hours >= 13,If(trigger = 1,hours,13),hours)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[StevieCho]

Thank you, you helped my 🙂 the dax formula is now :

Permanence calculée (NET) = IF (Imp_SQL_Conga[Permanence calculée (BRUT)]>=13, If(Imp_SQL_Conga[Trigger Weekend/Feriée] = 1,Imp_SQL[Permanence calculée (BRUT)],13),Imp_SQL[Permanence calculée (BRUT)])

[Mahesh0016]

@StevieCho Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.