cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
admin11
Memorable Member
Memorable Member

My Sales Table and Date Table unable to link ?

Hi All

 

I have a PBI file it work fine for last 3 year. Due to some issue happen now my sales table not link with date table. 

 

yesterday i make a post on how to recovery , But it does not help :-

https://community.powerbi.com/t5/Desktop/Seek-help-on-why-suddenly-i-need-go-to-advance-editor-to-re...

 

Now i need to go to first setp to bring back all the report. :-

 

I have check model , the sales table and date table is link :-

admin11_0-1653774625029.png

I have check the date table can display year number :-

admin11_1-1653774730474.png

I have try to add the Year table with sales amount , year not display any number :-

admin11_2-1653774772486.png

I have check sales table alone , it can display sales amount and date :-

admin11_3-1653774846752.png

 

Can some one advise me why sales table and date table not able link ?

 

Paul 

 

 

1 ACCEPTED SOLUTION
JamesFr06
Impactful Individual
Impactful Individual

The date column in sales date is a text column no a date colum

just change it and it should works

View solution in original post

6 REPLIES 6
JamesFr06
Impactful Individual
Impactful Individual

The date column in sales date is a text column no a date colum

just change it and it should works

@JamesFr06 

Thank you very much.

JamesFr06
Impactful Individual
Impactful Individual

And declare your date table as a reference date

JamesFr06_0-1653775529863.png

 

@JamesFr06 

I try to change the sales table date field from text to date format , i get error msg. Does it mean that i need to change at power quary ?

JamesFr06
Impactful Individual
Impactful Individual

No error on my side with your Pbix

admin11
Memorable Member
Memorable Member

Hi All

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors