Forum Discussion

siumui's avatar
siumui
Icon for Helper I rankHelper I
2 years ago
Solved

DAX Count consecutive days

  Hi,   I’m new to Dax.   For each ID I would like to add 1 column name Count.  This would count consecutive days and reset to 1 if not consecutive.  My data do not have weekends date.  So if th...
  • ThxAlot's avatar
    ThxAlot
    2 years ago

    Add a calendar table and an index column to facilitate the calculation; but it's never for a novice as it leverages embedded table iteration.

     

    (2023/11/23 is marked as non-working day on purpose; therefore 2023/11/24 is calculated as consecutive day)

ThxAlot's avatar
ThxAlot
Icon for Super User rankSuper User
2 years ago

Add a calendar table and an index column to facilitate the calculation; but it's never for a novice as it leverages embedded table iteration.

 

(2023/11/23 is marked as non-working day on purpose; therefore 2023/11/24 is calculated as consecutive day)

siumui's avatar
siumui
Icon for Helper I rankHelper I
2 years ago

Hi ThxAlot,

 

Saying thank you very much to you is simply not enough!  I truly appreciate and being grateful for your help.  It took me a while to create a dynamic calendar with working day and so forth.  Your codes works like a charm!  It turns out I need to count consecutive business days and your codes did it!!!  

 

Thank you so much for everything!  I have marked your codes as accepted solution.  Have a wonderful day!!  I hope you will continue to help others who need help just like me, getting stuck working on for a couple days and hitting dead end!  And you save the day!!!  THANK YOU!!!!