Forum Discussion
QQQ
Advocate II
Advocate IICreated Date Table in PowerBi, Joined it, but Data is missing
GitHub Repository with power bi file
Created Date Table in PowerBi per these instructions
Joined the tables
When I create simple table with Month and Matches, Month is blank
However if I display Month by itself, then the values show. HELP!
The column you have joined on (Standard Date) is a text column. You need to convert it to a Date column
2 Replies
- MattAllington
Community Champion
Which date column are you using your visual? Once you add a calendar table, you should never use the date column from your data table.
- MattAllington
The column you have joined on (Standard Date) is a text column. You need to convert it to a Date column