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
FILIPKACZMAR
Advocate I
Advocate I

Counting number of inspections using dates

Hello,

 

I have a sharepoint file with a list of inspections made for my company. I have columns there with a date of inspection and date of delivered report (from the inspection).

I want to count how many inspections have report delivered in less than 5 days. 

Can you help me? Thank you

Thank you 🙂 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi,

 

I would break the problem down into 2 steps.

 

1) Create a column with the difference between the two dates. Something like:

 

date difference = DATEDIFF(<Date1>, <Date2>)  

 

 

2) Next, create another column, [Difference of less than 5 days], that says

 

Difference of less than 5 days = if( [date difference] < 5, "Yes","No")

 

 (note that you can change the Y/N to boolean instead)

 

then in a table visualisation, you can add [Difference of less than 5 days] twice and change the setting of one of them to "Count of"

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi,

 

I would break the problem down into 2 steps.

 

1) Create a column with the difference between the two dates. Something like:

 

date difference = DATEDIFF(<Date1>, <Date2>)  

 

 

2) Next, create another column, [Difference of less than 5 days], that says

 

Difference of less than 5 days = if( [date difference] < 5, "Yes","No")

 

 (note that you can change the Y/N to boolean instead)

 

then in a table visualisation, you can add [Difference of less than 5 days] twice and change the setting of one of them to "Count of"

Thank you!

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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