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.
Hi,
Below is the relation between my tables. I need to calculate a value based on columns from Tables C & D or B & C.
Example: 'B'[Total] * 'C'[Engine_On]
Please help me achieve this as I am unable to find the table names while trying to create measures.
Thanks in advance.
Solved! Go to Solution.
Hi @jesly_ajin ,
If there is no relationship between these two tables, how do you determine the correspondence between the two columns you want to multiply? You can multiply them together by using aggregated values
e.g. MAX('B'[Total]) * MAX('C'[Engine_On])
Here is my sample data:
Measure = MAX('B'[Total])*MAX('C'[Engine_On])
Output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @jesly_ajin ,
If there is no relationship between these two tables, how do you determine the correspondence between the two columns you want to multiply? You can multiply them together by using aggregated values
e.g. MAX('B'[Total]) * MAX('C'[Engine_On])
Here is my sample data:
Measure = MAX('B'[Total])*MAX('C'[Engine_On])
Output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
97 | |
96 | |
80 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |