Forum Discussion
Solved
Overdue based on multiple Columns
Hi Team I'm trying to create a calculated column based on the below logic and wondering if anyone can help? The new Column will be the overdue in yellow. Any help is appreciated. Che...
hello ZachUnger
as far as i know, SWITCH() works similarly like IF(), so it will process the first line then second line and so on.
that happens because you have date info sent value less than today (initially this what i thought but looks like you want to have "No" if there is value in date info sent not matter what the value is).
Try removing this line or line 5 in your DAX, it should fix the issue.
Overdue =
SWITCH(
TRUE(),
'Table'[Date info sent]<>BLANK()&&'Table'[Date info sent]>TODAY(),"No",
'Table'[Required by]>TODAY(),"No",
'Table'[Extended to]<TODAY(),"Yes",
'Table'[Required by]<TODAY()&&'Table'[Extended to]>TODAY(),"No",
'Table'[Required by]<TODAY()&&'Table'[Extended to]<TODAY(),"Yes"
)
Hope this will help.Thank you.
you can create a conditional column or measure like this:
DateStatusMeasure =
IF(
ISBLANK(MAX(TableName[DateField])),
"No Date",
IF(
MAX(TableName[DateField]) < TODAY(),
"Past",
"Future"
)
)
modify it according to your needs