Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I am trying to create a table in power bi like the one listed below. Can anybody advise how to do that? Thanks!!
2024Rate column is a measure calculation.
2025Rate= 2024Rate +/- Increase Rate from raw data for each category.
table visulization:
category | 2024Rate | 2025Rate |
1 | 2% | 3% |
2 | 3% | 5% |
3 | 2% | 3% |
4 | 5% | 6% |
5 | 6% | 9% |
Raw data
category | Increase rate |
1 | 1% |
1 | 1% |
1 | 1% |
1 | 1% |
3 | 1% |
2 | 2% |
4 | 1% |
5 | 3% |
Solved! Go to Solution.
Step 1: I use 2 data tables.
'2024Rate' table:
'Raw data' table:
Step 2: I add a relationship.
Step 3: I add '2025Rate' column to '2024Rate' table.
2025Rate = [2024Rate]+CALCULATE(AVERAGE('Raw data'[Increase rate]),ALLEXCEPT('2024Rate','2024Rate'[category]))
Step 1: I use 2 data tables.
'2024Rate' table:
'Raw data' table:
Step 2: I add a relationship.
Step 3: I add '2025Rate' column to '2024Rate' table.
2025Rate = [2024Rate]+CALCULATE(AVERAGE('Raw data'[Increase rate]),ALLEXCEPT('2024Rate','2024Rate'[category]))
Thank you!!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
61 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |