Appended Query. Dates are not capturing in other columns

[Anonymous]

(PDate)

Hi guys, i have a Date column named (PDate) and when i append query from 4 other tables, the dates column from these 4 tables didnt show any value. Is there a way to solve this?

[v-yiruan-msft]

Hi @Anonymous ,

Could you please provide some sample data from the 4 other tables? If possible, it would be better to share your simplified pbix file. Later I need to check how you append these tables in your pbix file.

I created a sample pbix file(see attachment), you can refer it to append the tables.

1. Rename all of the date field in other 4 tables as "PDate"

2. Append these tables

Best Regards

[Anonymous]

Alright, i will try and let you know the result. Thanks anyway.

[v-yiruan-msft]

Hi @Anonymous ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[amitchandak]

@Anonymous ,All you dates seem to have different name. So that will show limited data(Only for the tbale have that name). Can you rename them before append 

[amitchandak]

@Anonymous , All you dates seem to have different name. So that will show limited data(Only for the tbale have that name). Can you rename them before append

[Anonymous]

I have renamed all the dates columns to PDate in the  4 tables as shown below.

I have Appended the Query 

#"Appended Query" = Table.Combine({#"Removed Other Columns", #"100%", TR, #"Cash Book", Loans}),

However, it still doesnt work that way. It is not reading per row.