Forum Discussion
Solved
DAX : If then else...
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 th...
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 👍
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 👍
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)])
