topic Counting number of inspections using dates in DAX Commands and Tips

Counting number of inspections using dates

FILIPKACZMAR — Thu, 06 Oct 2022 11:27:47 GMT

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 🙂

Re: Counting number of inspections using dates

Anonymous — Thu, 06 Oct 2022 12:19:13 GMT

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"

Re: Counting number of inspections using dates

FILIPKACZMAR — Fri, 07 Oct 2022 08:23:33 GMT

Thank you!