Forum Discussion
Solved
Multi Condition column
I am writing a DAX formula, where given the DATEDIFF in days between
Master_Data'[Dispo.ActualDispoDate] and 'Master_Data'[QC_Release_Date_BDS.QC_DATE] is less than or equal to 50 days, the formula returns "on time" or "Late" respectively.
However, there is one unique product that if the
DATEDIFF in days between Master_Data'[Dispo.ActualDispoDate] and 'Master_Data'[QC_Release_Date_BDS.QC_DATE] is less than or equal to 60 days, the formula should return the same output i.e. either "on time" or "Late" respectivel.
How do I capture this in one single DAX formula? See DAX formula below
Ykankam , the comma before 'Master_data[Product]' ="Pembrolizuab" should be and or or
means && and ||
In case it is and(&&) , but or condition in brackets ()
2 Replies
Ykankam , the comma before 'Master_data[Product]' ="Pembrolizuab" should be and or or
means && and ||
In case it is and(&&) , but or condition in brackets ()
thank you, amitchandak . It worked
