Forum Discussion
Solved
DAX - multiple conditions
Hello I'm trying to do simple filtering using multiple conditions. At least I thought it would be easy. Here are the columns: Amount AmountLeft EndDate status 100 50 2016.12.3...
I guess it works fine now in this version
Status = IF(Query1[BonusAmount] = 0 || Query1[BonusLeft] < 0 || Query1[EndDate] < TODAY() && Query1[EndDate] <> BLANK(); "CLOSED"; "active")
Am I right?
It working fine for me.
Check the date coolumn which datatype it is ?
create Calculated column .
Let me know what error if u getting.
Hello
Here is result in my powerbi
The "EndDate" column is Date type.
U have Blank in End_Date column that is the problem.
If it is blank , then what u have to do ? u have to add that condition too.