cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

## 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
Resolver I

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"

2 REPLIES 2
Resolver I

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!

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

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

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors