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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Newbie22
Resolver I
Resolver I

I need to track tickets that will due within the next 5 hours

Hi All,

 

Anyone knows how can I track tickets that will due within the next 5 hours? Is there any formula for that?

 

I have available columns "Ticket number" and "Due Date". I need to have a new column for tickets that will due within the next 5 hours. 

Below is an example

Ticket NumberDue Datewill due within the next 5 hours?
ABC12312/12/2022 11:50 PM

Yes

ABC45612/13/2022 12:00 AMYes
XYZ12312/13/2022 7:00 AMNo
XYZ45612/13/2022 9:00 AMNo
1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@Newbie22 Maybe:

Measure = 
  VAR __DueBy = NOW() + 5/24
  VAR __DateTime = MAX('Table'[Due Date])
  VAR __Result = IF(__DateTime <= __DueBy,"Yes","No")
RETURN
  __Result

@ 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Mikelytics
Resident Rockstar
Resident Rockstar

Hi @Newbie22 

 

Please see the follwoing example:

 

Base Data

Mikelytics_0-1670860318561.png

 

formula ( I used 8 hours sicnce at my place it was 16:52

next 5 Hours = 
var var_TimeOfLineItem = SELECTEDVALUE(Tickets[Due Date])
var var_TimeNow = NOW()
var var_DeltainHours = (var_TimeOfLineItem-var_TimeNow) * 24
var var_DeltaInHoursallowed = 8

RETURN
IF(var_DeltainHours >= 0 && var_DeltainHours <= var_DeltaInHoursallowed,1,0)

 

result

Mikelytics_1-1670860407738.png

can also use it as a filter

Mikelytics_2-1670860443203.png

 

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn

 

 

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!
Greg_Deckler
Super User
Super User

@Newbie22 Maybe:

Measure = 
  VAR __DueBy = NOW() + 5/24
  VAR __DateTime = MAX('Table'[Due Date])
  VAR __Result = IF(__DateTime <= __DueBy,"Yes","No")
RETURN
  __Result

@ 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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