Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
72 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
127 | |
31 | |
27 | |
24 | |
22 |