Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |