Count of working days between rest days (RRR) and displaying expected rested days

DAX
1

Hi,
I hope you are well .
I would like to request help for my current task.
I have to achieve what is marked in yellow below:

  1. Display the last rested date
  2. Count working days between two rested days
  3. Display the next resting date

image
image811×320 6.51 KB

My raw data looks like this in the image below:

image

051023_forum.pbix (17.8 KB)

I would be grateful for any help and guidance on my task.

Regards,

Iwona

2

Hi @Iwona ,

Thanks for posting the question.

I just wanted to know if is it going to be dynamic on your rest thing or number remains static and the filter will limit what we see.

Based on that i will look solution from M query side or DAX side.

Thanks

3

Hi @Anurag ,

Many thanks for your help.

This solution is dedicated for few thousands employees with every day refresh of dataset.

This solution has to be dynamic,
Because it counts and resets to zero, then continue counting again in the same loop.

Would do you advise @Anurag in that case ?

Grateful as always,

Iwona

4

Hi @Iwona ,

Thanks for replying . But that is not my question.

Let’s draw a scenario from your above-shared screenshot.

IF i pick 7/3/2023 as my date filter what will it show

Will it show the first line or the whole scenario change just because of that selection?

Hoping I made myself clear now.

5

@Anurag

I think I know what you mean now.

So the table should always show data for 90 last days .

Slicer will be used to choose one of the locations only.

90 days rolling would be a correct answer?

Thank you,

Iwona

6

HI @Iwona ,

image
image1037×654 38.2 KB

If this is what you are looking for I have attached the pbix in the post
I hope you can calculate the difference in date because I am not clear about its logic.

If this is not what we want let me know and in case you are not able to cal the difference then let me know the logic.

051023_forum_sol.pbix (24.4 KB)

7

Hi @Anurag

Please let me know if this explanation below makes more sense.

image
image867×673 20.6 KB

Grateful for your support in this matter.

Regards,
Iwona