Forum Discussion
Helper IIIDate join doesn't seem to be working
I'm trying to build a Dashboard that focus on results when a user selects a Month and Year (example only show data for June 2023).
I've created a Calendar Table as the base:
and the other two tables look like this:
Meeting:
Table 1:
I've joined them as follows:
When I make basic card visuals, the count works:
Add a filter, and it breaks:
All columns are formatted to short date. This should be relatively straightforward. Meeting & Table 1 are Excel imports.
Where is it going wrong?
Hi DrewSmith
Have you checked in Power Query Editor that none of the dates have hours? If so (even if you formatted it), try to split it. Here you have a link: https://www.exceljetconsult.com.ng/home/blog/power-query-split-date-and-time-into-separate-columns/
6 Replies
mlsx4Memorable Member
Hi DrewSmith
Have you checked in Power Query Editor that none of the dates have hours? If so (even if you formatted it), try to split it. Here you have a link: https://www.exceljetconsult.com.ng/home/blog/power-query-split-date-and-time-into-separate-columns/
- DrewSmith
Thank you. Setting up a new date column appears to have worked! Thank you.
- DrewSmith
As you suspect. Sorry, I should have said that the Month/Year filter was coming from the Calendar table.
