Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone,
On the one hand I have a table with the volume of a series of packages that I read from one source:
ID_Package | Volume[m3] |
926 | 11,87 |
1032 | 4,56 |
1274 | 8,69 |
1248 | 30,02 |
1215 | 17,14 |
1266 | 45,32 |
On the other hand I have different cattegories of packages based on minium and maximum volumes:
Volume_Min | Volume_Max | Package_Type_per_Volume |
0 | 2,5 | < 2,5 M3 |
2,5 | 7,5 | 2,5-7,5 M3 |
7,5 | 15 | 7,5-15 M3 |
15 | 30 | 15-30 M3 |
30 | 50 | 30-50 M3 |
50 | 99999 | >50 M3 |
Is there any way to include the "Package_Type_per_volume" info in the first table without using "IF" conditions? This second table can be easily modified and if I use IF conditions I will need to modify it each time I change the scale. The idea would be to get this table:
ID_Package | Volume[m3] | Package_Type_per_Volume |
926 | 11,87 | 7,5-15 M3 |
1032 | 4,56 | 2,5-7,5 M3 |
1274 | 8,69 | 7,5-15 M3 |
1248 | 30,02 | 30-50 M3 |
1215 | 17,14 | 15-30 M3 |
1266 | 45,32 | 30-50 M3 |
Thanks in advance!
Thanks, I will but it looks like it could work!
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |