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.
I'm creating a report for Trouble Tickets. I have 2 columns representing 'Date Created' and 'Date Completed'. The resulting Column('# of Days to Clear 2') from _datediff generates my results but I'm getting tickets closed on the same day and Tickets that do not have a value under 'Date completed' as 'remaining open'. How do I get same-day closed tickets to be a part of the 'Cleared in 7 days or less' .
see below:
Solved! Go to Solution.
@Delguy87 Instead of DATEDIFF, use:
Thanks for the reply. you helped me to a solution. this was what ended up working for me. For some reason, i was getting an error for ' >= 0 && <= 7'
thanks, that worked as well!
@Delguy87 Instead of DATEDIFF, use:
Thanks for the reply. you helped me to a solution. this was what ended up working for me. For some reason, i was getting an error for ' >= 0 && <= 7'
@Delguy87 That was short-hand. The actual code would have been _diff >= 0 && _diff <= 7
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
86 | |
85 | |
68 | |
67 | |
63 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |