Forum Discussion
Date table returns blank months
What seemed to do the trick was to in the query editor, go to the transform and extract the datetime value to just date.
Thanks for the help.
Super UserAnonymous ,
Take table and try to debug your data by dragging fields like YearMonthnumber, DateCOlumn, and sales amount. And take a closer look on Blank value of YearMonthnumber and its corresponding Date Column value.
Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.
I have, and it seems random. Can't find anything weird.
For me it seems to be some problem with the relationship.
- Tahreem24
Anonymous If possible so, can you please upload your PBIX file with Date Column and new Columns which you have created for Calendar only and mask your remaining data. SO, that I can check at my end and try to find the root cause of that issue.
Don't forget to give thumbs up 👍and accept this as a solution if it helped you.
I will do that.
Just before, is it possible that even though the date is changed to the format "Date", it is still stored as "Date time"?