Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
Tutorial Requests
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, Anonymous ;

You could create a flag measure.

flag = 
IF(MAX('Table'[start date])<MAX('Date'[Date])&&MAX('Table'[end date])>=MIN('Date'[Date]),1)

Then apply it into filter.

 

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.