Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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 🙂
Solved! Go to Solution.
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"
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!
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
12 | |
10 | |
9 | |
9 |