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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.