Matrix Visual - Multiple Data Types

[powebifan]

Hi everyone,

I'm looking to get the following output using the matrix visual but I can't seem to make it work. 

I have the start and end dates but I would like to calculate the duration as well and have it appear in this format:

Date	Original	Actual
Start Date	Jan 1, 2022	Jan 10, 2022
End Date	March 5, 2022	April 15, 2022
Duration	63	95

Thank you for looking!

[boris_s_hansen]

Hi PijushRoy

I'm trying to re-produce the same table as powebifan. I'm following your guide, but I'm not able to drag to values in the matrix. What am I doing wrong? Any help appreciated 🙂

Kind regards,

Boris.

[PijushRoy]

Hi @powebifan 

Go to Power Query Editor
Select the Date Column and Unpivot Other Column

Load the Data and Arrange as Matrix Table as below image

After than, change Sort by in Matrix Visual for arranging your data

Change the date format as per your requirement

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos