Forum Discussion
Same point in time If formula
The syntax for IF function in DAX is
IF(logical_test>,<value_if_true>, value_if_false)You do no need "Then" and "Else" keyword in DAX.
https://msdn.microsoft.com/en-us/library/ee634824.aspx?f=255&MSPPError=-2147217396
If this is not what you want, please provide us some sample data and elaborate your expected result, so that we can make further analysis.
Regards,
Charlie Liao
Microsoft Employee
The syntax for IF function in DAX is
IF(logical_test>,<value_if_true>, value_if_false)
You do no need "Then" and "Else" keyword in DAX.
https://msdn.microsoft.com/en-us/library/ee634824.aspx?f=255&MSPPError=-2147217396
If this is not what you want, please provide us some sample data and elaborate your expected result, so that we can make further analysis.
Regards,
Charlie Liao