Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi guys,
I hope you are all in good health and that this crisis will end quickly.
My doubt lies in comparing columns in a visualmatrix on the power bi.
I have made a matrix like this:
I made several measurements with power query, such average assignments times for a task, for each day
I also have a baseline data. The days are values based on a column called [dias], and the KPIs are a SUM of task durations and divided by the total tasks with appointment, tasks without appointment and total tasks count. Now I need to reach, in the same matrix, more columns, equal in number as the number of days, the comparison of the days with the baseline. I need to subtract the KPI information of the days with the baseline, as the following table:
As if "Run 1" and "Run 2" values were my days values. I hope you guys can help me, I have no idea how to make this comparison without two separete tables.
Thank you in advance for your help.
Hi @Anonymous ,
From the problem description some computations are done in Power Query.
Can you upload some data in excel and the output expected for the sample data to OneDrive or Google drive and share the link. It will also be good if you can share the pbix file with vital data masked
Cheers
CheenuSing
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.