Date Join to Date Range ( Start Date and End Date)

[Anonymous]

Hello,

I'm looking to join a Date field from DataTable  to StartDate and EndDate fileds in DateTable. Basically I'm trying to join like this: 

DataTable.Date between DateTable.StartDate and DateTable.EndDate 

Is it possible in power BI data modeling?

Thanks!

[Anonymous]

Hi @v-henryk-mstf 

Thanks for the reply. I have the date filed already in the table and I can use date slicer as an filter. But requirement is to use Button or Chicklet slicer to filter the data. For example, I have buttons with named Current Month, Current Week, Current Year & Last Month. User will just click on specific button to get the data for that time period. Is this possible?

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

You can create month and week fields separately, and then filter by clicking on the slicer:

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-henryk-mstf]

Hi @Anonymous ,

You can try to create a date table, and then select the date range through the filter and find the corresponding value, refer to the following:

If the problem is still not resolved, please provide detailed error information and a screenshot of the desired result. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.