The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello Community,
I hope you are good and wondering if you can help me please.
I'd like to create a new column called STATUS which says:
1) Before today = Overdue
2) Today = Due Today
3) After today = Upcoming
Thanking you very much in advance.
Solved! Go to Solution.
You could create a column like
Status =
VAR DaysDiff =
DATEDIFF ( TODAY (), 'Table'[Scheduled date], DAY )
RETURN
SWITCH (
TRUE (),
DaysDiff < 0, "Overdue",
DaysDiff > 0, "Upcoming",
"Due today"
)
Thank you Jon, it got me started. Much appreciated
You could create a column like
Status =
VAR DaysDiff =
DATEDIFF ( TODAY (), 'Table'[Scheduled date], DAY )
RETURN
SWITCH (
TRUE (),
DaysDiff < 0, "Overdue",
DaysDiff > 0, "Upcoming",
"Due today"
)
User | Count |
---|---|
28 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
33 | |
13 | |
12 | |
9 | |
7 |