Forum Discussion
grggmrtn
7 years agoPost Patron
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...
- 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
v-lili6-msft
7 years agoCommunity Support
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
- grggmrtn7 years agoPost Patron
Hey v-lili6-msft thanks for looking at this. I came to the same conclusion, should have thought of it earlier ;)
Thanks :)