Forum Discussion

grggmrtn's avatar
grggmrtn
Post Patron
7 years ago
Solved

Creating DaysLIst rows between start/stop dates, while limiting how many? [M]

In order to slice dates the way I need to, I use a code to add a rowfor each day between a start and stop date in my table. The table looks something like this: Person Service Start date Stop date 1...
  • v-lili6-msft's avatar
    7 years ago

    hi, grggmrtn 

    You could add another flag column for that's who really stopped today and who just has today as stopdate after you doing a simple calculated column.

    Then use this column for slicer or as a flag.

    If not your case, please share more sample data and your expected output.

     

    Best Regards,

    Lin