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.
Hi all,
Bit of a tricky one here.
I've created a date table from 2019-2021, which includes a Y/Blank on working days so I can figure out the total days a ticket is open, by minusing two dates against each other. To make this accurate, I need to use this date table to not count the weekends and bank holidays in the year.
So a rough idea of what I'm trying to achieve will be:
"Complaint Received" (complaints table) minus "Final Response Sent" (complaints table), ignoring blanks in "Working Day" (date table).
Date table featuring weekend and bank holiday info^
Complaints recieved column and table (underlined) needed for DAX^
"Final Response Sent" column and table (underlined) needed for DAX ^
Kind regards,
Jordan
Solved! Go to Solution.
@Anonymous
You can add it as a calculated column to your complaints table like so.
Working Days =
CALCULATE (
COUNTROWS ( DateTable ),
DATESBETWEEN ( DateTable[Date], 'MGA - Complaints (SCANS)[Complaint Received], 'MGA - Complaints (SCANS)[Finla Response Sent] ),
DATES[Working Day] = 'Y'
) -1
The pattern is from this article: https://www.sqlbi.com/articles/counting-working-days-in-dax/
@Anonymous
You can add it as a calculated column to your complaints table like so.
Working Days =
CALCULATE (
COUNTROWS ( DateTable ),
DATESBETWEEN ( DateTable[Date], 'MGA - Complaints (SCANS)[Complaint Received], 'MGA - Complaints (SCANS)[Finla Response Sent] ),
DATES[Working Day] = 'Y'
) -1
The pattern is from this article: https://www.sqlbi.com/articles/counting-working-days-in-dax/
@Anonymous , for open tickets, referhttps://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
For working day calculation refer the second Page
https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0
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 |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |