Measure Help

[vincenttys]

Hi all,

I have attached a sample of the data set in the link provided below. Column highlighted in yellow is a calculated column based on Entry Time Deviation and Exit time Deviation. 

I want to use the data in the data tab and generate a report similar to the "Report" tab - Ideally in the matrix table format in powerbi.

Anyone able to help.

Below is the link to the file

Sample.xlsx

[lucadelicio]

Hi Vinc,
here the link of your project.
Enjoy and set my answer as solution.
Thank you

[vincenttys]

Hi @lucadelicio 

Thanks for your response.

Unfortunately, I want to present the data in the exact format as what i have in my "Report" tab using PowerBI Matrix visual

Thank you

Regards,

Vince

[lucadelicio]

Set a google meet on [email protected] i'll be happy to help you.

[lucadelicio]

Hi Vinc,
the link is not avalaible.

Try to use https://wetransfer.com/ to create a link to download.

Thank you i'll be happy to help you.

[vincenttys]

Hi @lucadelicio 

Thanks for making me aware the link is not working.

I have added the file in the link below and hopefully this time it work.

https://we.tl/t-xurPp2zg8A.

Thank you

Regards,

Vince