Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
56 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |