Forum Discussion
Slicing date interval on weeks
Hello everyone. I have a problem filtering date interval on weeks when the date interval is more than 1 week. I have multiple activities trough out the year. I want to be able to select a spec...
I fixed it by turning every date in the interval from start to end into a new line in power query.
Following link provides a quide to do so.
https://apexinsights.net/blog/convert-date-range-to-list
Hey v-yalanwu-msft
Thanks for the answer!
Is there a way to make this work with a relation to the time table? It only works if I remove the relation, but that will ruin other visuals.
I fixed it by turning every date in the interval from start to end into a new line in power query.
Following link provides a quide to do so.
https://apexinsights.net/blog/convert-date-range-to-list