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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ievazal
Frequent Visitor

DateTime comparisons

Hello!

 

I have a table that shows data on when visits are created for different buildings and when the visitor has checked-in.

 

BuildingVisit created onCheck-in time
A1-08-2023 11:03:002-08-2023 14:00:00
B2-08-2023 12:00:002-08-2023 13:00:00
C4-08-2023 12:02:024-08-2023 14:00:00
D5-08-2023 9:00:057-08-2023 8:05:00

 

How could I check if a visit has been created after 4PM the previous day the visitor has come in and bring back the amount of such visits?

 

Thank you in advance!

1 REPLY 1
christinepayton
Super User
Super User

SQL BI has a good article on how to add/remove date time in measures here:

https://www.sqlbi.com/blog/alberto/2019/03/25/using-dax-with-datetime-values/

 

You could use variables to store all the things you're comparing. My roundabout guesstimate to get the 4pm the day before for comparison would be to subtract a day from the given date, convert it to date only, then convert it back to date time and add the hours up to 4pm to it. Then you can compare it to the date field in your data and return a true/false if it's greater than or less than the 4pm prior day. 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors