Forum Discussion
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 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 🙂
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 👍
4 Replies
StevieCho Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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)])
Thank you Guys, i'll ty it later 🙂
