Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
vincenttys
Frequent Visitor

Measure Help

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

 

5 REPLIES 5
lucadelicio
Super User
Super User

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

Luca D'Elicio

https://www.linkedin.com/in/luca-d-elicio-74a481158/

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

 

Report.PNG

 

Thank you

 

Regards,

Vince

 

 

lucadelicio
Super User
Super User

Set a google meet on lucadelicio@gmail.com i'll be happy to help you.

Luca D'Elicio

https://www.linkedin.com/in/luca-d-elicio-74a481158/
lucadelicio
Super User
Super User

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.

Luca D'Elicio

https://www.linkedin.com/in/luca-d-elicio-74a481158/

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors