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 a two tables are Floor Size and Vehicle Size.
In Floor Size table the following columns are Floor Size Type, length, width, height and rank.
I created rank for each type based on the floor size dimension. The purpose of the rank column were multiple matches for same car. (Example- length – 320, Width-320, Height-320 it will fit all the Floor Size Types but we have to choose appropriate floor size- Please refer the line item 12 in the snapshot)
In report table I have following columns are list of vehicle size, length, width and height.
I am trying to find out the appropriate floor size for each vehicle.
I am looking for new calculate column options
Any advise please.
"I am trying to find out the appropriate floor size for each vehicle."
What does that mean? The smallest floor size that the car fits in? By what? By "wasted volume" ? Do you need to be able to open the car door (which would add to the width requirement)?
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |