Forum Discussion
Date IF Statement
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 - 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.
Many thanks Greg and noted on the checking first. 🙂