cancel
Showing results 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

## 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"

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!