Conditional Column

RaulChoque — Mon, 05 Aug 2019 14:48:47 GMT

Please I would like to develop a conditional column with the following rule: If Today Vs Due Day is equal or greater than 0, the result should be "On Time", but if Today Vs Due Day is less than 0 and the Code is #Q the result should be "Observed", and if Today Vs Due Day is less than 0 and the Code is blank or other value, the result should be "Delayed". Any help. Thank you.

Re: Conditional Column

Anonymous — Tue, 06 Aug 2019 10:57:56 GMT

Column =
switch ( TRUE(),
	T[TVDD] >= 0, "On Time",
	T[TVDD] < 0 && T[Code] = "#Q", "Observed",
	"Delayed"
)

Best

topic Re: Conditional Column in DAX Commands and Tips

Conditional Column

Re: Conditional Column