Forum Discussion
Date IF Statement
Hi All, I'm trying many different things but getting myself more confused.. i'm trying to acheive a simple calculated column based upon a date field. If the date field is greather than today+30, sh...
Anonymous - I'm thinking:
Column = SWITCH(TRUE(), [Date] < TODAY(),"Expired", [Date] > TODAY() + 30,"Good", "About to Expire" )BTW, since I see that you are a New Member:
Please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Anonymous - If I understand, yes:
Column =
SWITCH(TRUE(),
ISBLANK([Date]),"Good",
[Date] < TODAY(),"Expired",
[Date] > TODAY() + 30,"Good",
"About to Expire"
)Perfect .. thank you.