Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a date when a file was created, but there is a condition based on another column called group that:
if Table[group] = Critical, and the date created>30 days then days should start counting to current date
if Table[group] = High, and the date created>30 days then days should start counting to current date
if Table[group] = Medium, and the date created>60 days then days should start counting to current date
if Table[group] = low, and the date created>90 days then days should start counting to current date
Attached is a sample and my calculation logic
Solved! Go to Solution.
@Anonymous Try:
Column =
VAR __Today = TODAY()
VAR __Date = [Date]
VAR __DiffDays = ( __Today - __Date ) * 1.
RETURN
SWITCH([Group],
"Medium", __DiffDays - 60,
"Low", __DiffDays - 90,
__DiffDays - 30
)
@Anonymous Try:
Column =
VAR __Today = TODAY()
VAR __Date = [Date]
VAR __DiffDays = ( __Today - __Date ) * 1.
RETURN
SWITCH([Group],
"Medium", __DiffDays - 60,
"Low", __DiffDays - 90,
__DiffDays - 30
)
Thank you @Greg_Deckler I just notices something that I am getting negative count of days if the Added conditinal days is not satisfied yet, How do I correct this
@Anonymous Try:
Column =
VAR __Today = TODAY()
VAR __Date = [Date]
VAR __DiffDays = ( __Today - __Date ) * 1.
RETURN
SWITCH(TRUE(),
[Group] = "Medium" && __DiffDays >= 60, __DiffDays - 60,
[Group] = "Low" && __DiffDays >= 90, __DiffDays - 90,
__DiffDays >= 30, __DiffDays - 30,
0 //or whatever you want to return in the event none of the conditions are met
)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |