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 all,
Is there a way to get only weekdays (exclude weekends) for the next 6 months based on today's date in measure
Ex:Today() + 180 days and exclude weekends.
TIA
Solved! Go to Solution.
Hi @Puja Below is code for creation of calculated tables with dates.
Did I answer your question? Mark my post as a solution! Kudos Appreciated!
Proud to be a Super User!
Hi @Puja Below is code for creation of calculated tables with dates.
Did I answer your question? Mark my post as a solution! Kudos Appreciated!
Proud to be a Super User!
Hi @Puja for measure one of approach is as shown below:
Did I answer your question? Mark my post as a solution! Kudos Appreciated!
Proud to be a Super User!
Hi @some_bih ,
Thank you . I need to get DATES and not number (129). Sorry I was not clear in my request.
Like below exclude weekends.
7/11/2023 |
7/11/2023 |
7/11/2023 |
7/11/2023 |
7/11/2023 |
7/11/2023 |
7/12/2023 |
7/12/2023 |
7/12/2023 |
7/12/2023 |
7/12/2023 |
7/12/2023 |
7/13/2023 |
7/13/2023 |
7/13/2023 |
7/13/2023 |
7/13/2023 |
7/13/2023 |
7/14/2023 |
7/14/2023 |
7/14/2023 |
7/14/2023 |
7/14/2023 |
7/14/2023 |
7/17/2023 |
7/17/2023 |
7/17/2023 |
7/17/2023 |
7/17/2023 |
7/17/2023 |
7/18/2023 |
7/18/2023 |
7/18/2023 |
7/18/2023 |
7/18/2023 |
7/18/2023 |
7/19/2023 |
7/19/2023 |
7/19/2023 |
7/19/2023 |
7/19/2023 |
User | Count |
---|---|
68 | |
47 | |
21 | |
19 | |
15 |
User | Count |
---|---|
123 | |
42 | |
39 | |
26 | |
24 |