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
Anonymous
Not applicable

Wrong Matching between two column date

Hello, I have a problem between my calendar table and another table. The join between my date column from the calendar and the date column from the other table is failing to match. There is no date match, yet both columns are in "date" format.
I specify my date range in the calendar table is from 2000 to 2030 to verify but it does not help
Never see that before...

 

ty guys..

 

TABLEDATE.PNG111.PNG1111.PNGtabledate2.PNG

1 ACCEPTED SOLUTION
Anonymous
Not applicable

I ended up finding the solution. In power query these famous columns were originally in text format. They were then changed to date time type. By modifying again from the query editor to the simple date format. It works ! Note that changing the format outside of power query did not solve the problem.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

I ended up finding the solution. In power query these famous columns were originally in text format. They were then changed to date time type. By modifying again from the query editor to the simple date format. It works ! Note that changing the format outside of power query did not solve the problem.

Fowmy
Super User
Super User

@Anonymous 

 

Prior to doing the matching, check the Data Types of both the fields and change it to Date if required.
Also, check if there are matching dates exist in both tables.

Hope you are using the correct join type

 

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂


Website YouTube  LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

PC2790
Community Champion
Community Champion

Can you try and make the format of both the columns same and see if that works?

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.