Forum Discussion
IF function not working
Hi, Can someone explain me what's wrong with this formula? Thanks
Anonymous
If you are creating a measure then, this shouldMeasure = if ( MAX(table[Due Date]) = "null", "9999", MAX(table[Resolution Date]) - MAX(table[Due Date]) )work.
So you are doing it in Power Query, this should work:
Table.AddColumn(#"Colonnes renommées13", "Major", each if [Priority] = "Major" and [Issue Type] = "Bug" then 1 else 0)Anonymous
You can add as a column to your table using DAX:Major = if ( and([Priority] = "Major" , [Issue Type] = "Bug" ) , 1 , 0)
Anonymous
If you are creating a measure then, this should
Measure =
if (
MAX(table[Due Date]) = "null", "9999", MAX(table[Resolution Date]) - MAX(table[Due Date])
)work.
Thanks Fowmy
what about this one?
= Table.AddColumn(#"Colonnes renommées13", "Major", each if( [Priority] = "Major" and [Issue Type] = "Bug" )then 1 else 0)
So you are doing it in Power Query, this should work:
Table.AddColumn(#"Colonnes renommées13", "Major", each if [Priority] = "Major" and [Issue Type] = "Bug" then 1 else 0)Actually I was trying to transform this power query formula to DAX Fowmy
Anonymous
You can add as a column to your table using DAX:Major = if ( and([Priority] = "Major" , [Issue Type] = "Bug" ) , 1 , 0)