My inventory date link with master cal the date wrong

[Paulyeo11]

Hi All

My Inventory i can convert the date , but after link it give wrong date.

https://www.dropbox.com/s/95mi1zmbga1go5s/INVC%20ISDN%20V006%20Move%20date%20after%20link%20not%20wo...

[Icey · Accepted solution]

Hi @Paulyeo11 ,

There is no issue. Your relationship is based on 'Table'[Last Sold Date] and 'Date'[Date]. 

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@Paulyeo11 , You are using the wrong table combination. I renamed the table for better understanding. Please find the attached file

[Paulyeo11]

Hi Amit

I have open your the PBI file . I still notice the date is not same with master cal date.

https://www.dropbox.com/s/1sozj7g6wuoyaxx/INVC%20ISDN%20V006%20AMIT.pbix?dl=0

[Paulyeo11]

Hi Amit

this msg , does it mean that the data is not in my harddisk , so i need to link the raw data right ?

[manikumar34]

@Paulyeo11 , 

It menas you have some pending changes done on Power query to be applied to data table.

Regards,

Manikumar

[Anonymous]

You link the date that is in your data. Not the date you see on screen. My guess is you changed the display format of the date and think that will be the date passed in a link. Your assumption probably is incorrect