cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mchandler
Frequent Visitor

Tickets last updated more than 48 hours ago

Good afternoon all, 

 

I am a little stumped. I am trying to display the number of tickets that have not been updated in the last 48 hours. My roadblock

is when I try to use the relative time filter on the report builder screen. I just learned there is not a filter for "not in the last X"

So I guess I need to build this in a measure then filter based on the other items. This is where I am having the issue. I cannot figure out how to build this measure.

 

The [Last Updated Date] is a format of mm/dd/yyyy 11:59:59 AM

 

The other items are "Agent Group" and "Status". My visual is a card that will tell me the number of Partner Support Tickets that have not been updated in the last 48 hours. 

Anyone have a suggestion?

Screen Shot 2021-10-25 at 5.04.03 PM.png

1 ACCEPTED SOLUTION
TheoC
Memorable Member
Memorable Member

Hi @mchandler 

 

Give this a quick try as a Calculated Column:

 

Check = 

VAR _MaxDate = MAX ( tblDateTime[Value] )
VAR _MaxLess48 = _MaxDate - 2

RETURN

IF ( tblDateTime[Value] <= _MaxLess48 , 1 , 0 )

 

It will return a 1 for everything greater than 2 days old and a 0 for anything prior to that.  You should be able to drag the column across into the Filter pane and remove the "0".

 

 
TheoC_3-1635205383064.png

 

 

Hope this helps 🙂

 

Theo

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?  www.linkedin.com/in/theoconias

View solution in original post

1 REPLY 1
TheoC
Memorable Member
Memorable Member

Hi @mchandler 

 

Give this a quick try as a Calculated Column:

 

Check = 

VAR _MaxDate = MAX ( tblDateTime[Value] )
VAR _MaxLess48 = _MaxDate - 2

RETURN

IF ( tblDateTime[Value] <= _MaxLess48 , 1 , 0 )

 

It will return a 1 for everything greater than 2 days old and a 0 for anything prior to that.  You should be able to drag the column across into the Filter pane and remove the "0".

 

 
TheoC_3-1635205383064.png

 

 

Hope this helps 🙂

 

Theo

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?  www.linkedin.com/in/theoconias

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.