My PBI File :-
My Raw data is correct :-
After import into PBI , the date become :-
Solved! Go to Solution.
I tried doing some changes in your pbix, but nothing worked. This is quite weird that dates are changing in the data model but seems correct in power query.
I would advice you to go back to your data source and make it a date there. It seems that this is an excel issue, where excel and read different formats but Power BI cannot reference that correctly sometimes. If your data source is excel only then please select your date column and press CTRL+SHIFT+3 that would change it to date.
Please try after that and let me know did it worked?
It's just a format issue.
Pleasse select the desired format of AR Invoice date column like below-
Appreciate your kudos !! Please mark my post as solution if it helps.
@Paulyeo11 , This correct. Your format is YY MMM, mean Year (YY) and month
And in one row you do not have the date, That is showing as blank. (Deafult is right)
You case use YYYY MMM format or MMM YYYY format
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.