Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
moons
Helper I
Helper I

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

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!

1 ACCEPTED SOLUTION

Hi @moons ,

 

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

v-henryk-mstf_1-1622616640553.png

 

v-henryk-mstf_0-1622616622864.png


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.

View solution in original post

3 REPLIES 3
moons
Helper I
Helper I

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?

Hi @moons ,

 

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

v-henryk-mstf_1-1622616640553.png

 

v-henryk-mstf_0-1622616622864.png


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
Community Support
Community Support

Hi @moons ,

 

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:

v-henryk-mstf_0-1622445202182.pngv-henryk-mstf_1-1622445215408.pngv-henryk-mstf_2-1622445226683.png


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.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.