I unable to link Posting Date with Master Calendar ?

[admin11]

Hi All

I have just load a GL table , there is a Posting Date field , i have link this field to Master Calendar .

I also have try to use PQ to change Type Posting Date to US date and England date .

But still unable to link to master calendar date.

When i try to filter year = 2020 , no data list on straight table. Hope some one can advise me where go wrong ?

Paul

[admin11]

Hi All

My PBI file :-

https://www.dropbox.com/s/4oelovy9otdvp04/APPEND%202%20GL%20INTO%201%20V003.pbix?dl=0

[amitchandak · Accepted solution]

@admin11 , I opened and correct the join, It seems to be working. File attached

[admin11]

@amitchandak 

Thank you it work now. very funny not sure why ?