Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two tables as per below
Balance | |
Year-Period | Total |
2021-01 | 872754 |
2021-02 | 849699 |
2021-03 | 846236 |
2021-04 | 804638 |
2021-05 | 797641 |
2021-06 | 820140 |
2021-07 | 797847 |
2021-08 | 795613 |
2021-09 | 778706 |
2021-10 | 783681 |
2021-11 | 807549 |
2021-12 | 807932 |
2022-01 | 801786 |
Values | |
Year-Period | Turnover |
2021-01 | 194866 |
2021-02 | 241215 |
2021-03 | 219672 |
2021-04 | 217108 |
2021-05 | 198586 |
2021-06 | 169087 |
2021-07 | 166488 |
2021-08 | 204115 |
2021-09 | 198671 |
2021-10 | 202633 |
2021-11 | 229480 |
2021-12 | 206510 |
2022-01 | 184861 |
So the end result should be something like
Values | ||
Year-Period | Value | Ratio |
2021-01 | 194866 | 0.223277 |
2021-02 | 241215 | 0.283882 |
2021-03 | 219672 | 0.259587 |
2021-04 | 217108 | 0.269821 |
2021-05 | 198586 | 0.248966 |
2021-06 | 169087 | 0.206168 |
2021-07 | 166488 | 0.208671 |
2021-08 | 204115 | 0.256551 |
2021-09 | 198671 | 0.255129 |
2021-10 | 202633 | 0.258565 |
2021-11 | 229480 | 0.284169 |
2021-12 | 206510 | 0.255603 |
2022-01 | 184861 | 0.230561 |
I need to calculate a ratio by dividing the amount in the Turnover column in the Value table, by the Total Column in the Balance Table (for each row). I have created a relationship between the tables (based on the Year-Period) column.
The Balance column is actually a calculated column (but I dont believe that should make a difference) and both tables actually have other columns I am using for different visulisations
This should be simple, (and it is in sql or Excel), but I am new to PowerBI and I am struggling. I can calculate a ratio of the totals of each column, but not a row by row result
Solved! Go to Solution.
you can try this
Column = 'values'[Turnover]/ RELATED(balance[Total])
pls see the attachment below
Proud to be a Super User!
you can try this
Column = 'values'[Turnover]/ RELATED(balance[Total])
pls see the attachment below
Proud to be a Super User!
Thank you !!
It was the "Related" part I was missing
you are welcome
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |