cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Paulyeo11
Impactful Individual
Impactful Individual

My Date after import to PBI the date become wrong ?

Hi All

My PBI File :-

https://www.dropbox.com/s/5leoe9mhecycfa2/SI_CSV_v005.pbix?dl=0

 

My Raw data is correct :-

Paulyeo11_0-1602227239923.png

 

 

 

After import into PBI , the date become :-

Paulyeo11_1-1602227353504.png

 

1 ACCEPTED SOLUTION
VijayP
Super User I
Super User I

@Paulyeo11 

You need to Clean your Data , Because of few blanks in the data , your DateDim is creating long list of dates

 




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


View solution in original post

6 REPLIES 6
VijayP
Super User I
Super User I

@Paulyeo11 

You need to Clean your Data , Because of few blanks in the data , your DateDim is creating long list of dates

 




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


View solution in original post

@Paulyeo11

Kindly Share your Kudoes, Just clik on the Like 👍button next to my Replies/Messages Thanks




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Paulyeo11
Impactful Individual
Impactful Individual

Thank you very much I willl look into it

AnkitKukreja
Responsive Resident
Responsive Resident

Hi @Paulyeo11 

 

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?

 

Thnaks,

Ankit

Thanks,
Ankit Kukreja
NikhilKumar
Super User II
Super User II

@Paulyeo11 ,

 

It's just a format issue.

 

Pleasse select the desired format of AR Invoice date column like below- 

Year.PNG

 

Appreciate your kudos !! Please mark my post as solution if it helps.


Nikhil
Hit the Thumbs-up button if you find this informative!!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!

amitchandak
Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

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.

Top Solution Authors
Top Kudoed Authors