Forum Discussion
QQQ
8 years agoAdvocate II
Created 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
- MattAllingtonCommunity 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.
- MattAllingtonCommunity Champion
The column you have joined on (Standard Date) is a text column. You need to convert it to a Date column