Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Super User

@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
Super User

@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!


@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
Super User
Super User

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

If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.
Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904
Anonymous
Not applicable

@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.

amitchandak
Super User
Super User

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.