Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Conditional Count of days to date

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 logicCapture.PNG

1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

@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
  )


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Community Champion
Community Champion

@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
  )


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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
  )


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.