Forum Discussion
Solved
Switch value between dates
Hi All, I currently have the column Dax script in a custom column. Depending on the date within the 'Service_expiry_date' column it will return the status of the service ("expired", "expiring wit...
DBC01
You can try:Cert status =
VAR _today = TODAY()
VAR _fiveDaysAgo = _today - 5
VAR _date = EDATE(_today, 1) - 1
RETURN
SWITCH(
TRUE(),
[service_expiry_date] > _fiveDaysAgo && [service_expiry_date] <= _today, "Test expired within last 5 days",
[service_expiry_date] <= _fiveDaysAgo, "Test expired",
[service_expiry_date] <= _date, "Test Expiring within 1 month",
[service_expiry_date] > _date, "Test not yet due",
"Check data" -- This is a catch-all for any unexpected results
)
DBC01
You can try:
Cert status =
VAR _today = TODAY()
VAR _fiveDaysAgo = _today - 5
VAR _date = EDATE(_today, 1) - 1
RETURN
SWITCH(
TRUE(),
[service_expiry_date] > _fiveDaysAgo && [service_expiry_date] <= _today, "Test expired within last 5 days",
[service_expiry_date] <= _fiveDaysAgo, "Test expired",
[service_expiry_date] <= _date, "Test Expiring within 1 month",
[service_expiry_date] > _date, "Test not yet due",
"Check data" -- This is a catch-all for any unexpected results
)
Thank you Kedar for this, it works exactly as I'd hoped! 🙂
