topic Re: Transposing and creating a table with Dates in DAX Commands and Tips

Transposing and creating a table with Dates

Anonymous — Sat, 27 Mar 2021 12:50:21 GMT

Trying to transpose cities and have a table with all dates by City. Attempting to acheive the image after this table.

Countries	Cities	Entry date	Exit date	Travel Date	Stamp Date
Belgium	Brussels	3/12/2019	5/12/2020	12/10/2018	11/5/2018
Japan	Osaka	10/18/2019	9/30/2019	10/15/2019	6/12/2019
England	London	2/14/2017	2/27/2017	2/12/2017	1/1/2017
Switzerland	Zurich	5/22/2019	10/12/2019	5/20/2019	3/12/2019
Finland	Helsinki	12/8/2020	3/6/2021	10/3/2020	7/1/2020
Belgium	Antwerp	3/15/2019	5/4/2020	3/12/2019	12/17/2018
Japan	Tokyo	10/18/2019	9/30/2019	10/15/2019	6/12/2019
England	Bristol	2/14/2017	2/27/2017	2/12/2017	1/1/2017
Switzerland	Lugano	5/22/2019	10/12/2019	5/20/2019	3/12/2019
Finland	Oulu	12/8/2020	3/6/2021	10/3/2020	7/1/2020

Re: Transposing and creating a table with Dates

AntrikshSharma — Sat, 27 Mar 2021 13:44:46 GMT

Anonymous Are you trying to create a visual like the following? The file is attached below my signature:

Re: Transposing and creating a table with Dates

Anonymous — Sat, 27 Mar 2021 18:30:47 GMT

Thanks for the feedback, that was super helpful pointing me towards a matrix table, I was trying to use just a table only. however I will like to include countries in row and get this result below: