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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.