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.
Hello,
I have two tables called "Carriage" and "Limits".
The table "Carriage" contains the columns Date and Carriages. The another Table consists only of one row with multiple columns.
I want to create a new conditioned column in the table "Carriage" where I want to divide the Carriages of the Dates with the only one value of the column "Limit 1" of table "Limits".
Something like that:
Load = Value.Divide([Carriage1], from table "Limits" [Limit1])
Solved! Go to Solution.
Hey @Clout ,
are these two tables connected?
Otherwise you could try the following measure as a new column:
myDivision =
DIVIDE(
'Carriage'[Carriages],
MAX( 'Limits'[Limit 1] )
)
Hey @Clout ,
are these two tables connected?
Otherwise you could try the following measure as a new column:
myDivision =
DIVIDE(
'Carriage'[Carriages],
MAX( 'Limits'[Limit 1] )
)
Thank you!
I can do it trough the measure.
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 |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |