Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Relate two table without a Key with conditional

Hi guys Could someone tell me if what I need do is possible? I'm really lose with this problem. I have two tables, in the table "One" I have one colum of "Volume" where you can find tha quantity of...
Need Help DAX
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 
    Ok. Please try

    Number of Vehicles = 
VAR CurrentVolum = SELECTEDVALUE ( Salles[Volume] )
VAR MAXCapacity = MAX ( Carriers[CAPACIDADE DE] )
RETURN
IF ( 
    NOT ISBLANK( CurrentVolum ),
    ROUNDUP ( DIVIDE ( CurrentVolum, MAXCapacity ), 0 )
)
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Anonymous 

would you please share a copy/paste sample data?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi tamerj1 

 

Yes, Here is it

Sorry past it without formatting, but the community did allowed past the table

carrier table 1

City TIPO Carrier CAPACIDADE DE CAPACIDADE ATÉ
BARUERI FIORINO JADLOG 1 210
BARUERI VAN JADLOG 211 750
BARUERI VUC JADLOG 751 1.500
BARUERI 3/4 JADLOG 1501 2.000
BARUERI TOCO JADLOG 2001 3.000
BARUERI TRUCK JADLOG 3001 5.000
BARUERI CARRETA JADLOG 5001 14.000
CAMPINAS FIORINO JADLOG 1 195
CAMPINAS VAN JADLOG 196 585
CAMPINAS VUC JADLOG 586 780
CAMPINAS 3/4 JADLOG 781 1.200
CAMPINAS TOCO JADLOG 1201 2.000
CAMPINAS TRUCK JADLOG 2001 3.000
CAMPINAS CARRETA JADLOG 3001 5.200
CAMPINAS FIORINO SEQUOIA 1 190
CAMPINAS VAN SEQUOIA 191 570
CAMPINAS VUC SEQUOIA 571 760
CAMPINAS 3/4 SEQUOIA 761 1.140
CAMPINAS TOCO SEQUOIA 1141 1.900
CAMPINAS TRUCK SEQUOIA 1901 3.600
CAMPINAS CARRETA SEQUOIA 3601 5.800
RIO DE JANEIRO FIORINO JADLOG 1 210
RIO DE JANEIRO VAN JADLOG 211 750
RIO DE JANEIRO VUC JADLOG 751 1.500
RIO DE JANEIRO 3/4 JADLOG 1501 2.000
RIO DE JANEIRO TOCO JADLOG 2001 3.000

 

Table two - salles

Data Carrier City Volume
08/07/2022 Sequoia BARUERI 54241
12/07/2022 Sequoia BARUERI 48878,5
13/07/2022 Sequoia BARUERI 44610
11/07/2022 Sequoia BARUERI 43092
08/07/2022 Jadlog BARUERI 38771,5
12/07/2022 Jadlog BARUERI 34879,5
14/07/2022 Sequoia BARUERI 33927
13/07/2022 Jadlog BARUERI 32173
11/07/2022 Jadlog BARUERI 30597,5
09/07/2022 Sequoia BARUERI 29130
14/07/2022 Jadlog BARUERI 24706,5
15/07/2022 Sequoia BARUERI 24013
19/07/2022 Sequoia BARUERI 23937
07/07/2022 Sequoia BARUERI 22917,5
26/07/2022 Sequoia BARUERI 22841,5
27/07/2022 Sequoia BARUERI 20938
09/07/2022 Jadlog BARUERI 20722
20/07/2022 Sequoia BARUERI 20303,5
29/07/2022 Sequoia BARUERI 19669
28/07/2022 Sequoia BARUERI 19669
21/07/2022 Sequoia BARUERI 19213,5
06/07/2022 Sequoia BARUERI 18774
15/07/2022 Jadlog BARUERI 17604,5
19/07/2022 Jadlog BARUERI 17482
26/07/2022 Jadlog BARUERI 16859
07/07/2022 Jadlog BARUERI 16793,5
22/07/2022 Sequoia BARUERI 16669
27/07/2022 Jadlog BARUERI 15454,5
05/07/2022 Sequoia BARUERI 15314
20/07/2022 Jadlog BARUERI 14986
18/07/2022 Sequoia BARUERI 14897,5
29/07/2022 Jadlog BARUERI 14517,5
28/07/2022 Jadlog BARUERI 14517,5
01/07/2022 Sequoia BARUERI 14224,5
21/07/2022 Jadlog BARUERI 14181,5
25/07/2022 Sequoia BARUERI 13958,5
06/07/2022 Jadlog BARUERI 13810,5
22/07/2022 Jadlog BARUERI 12303
04/07/2022 Sequoia BARUERI 11846,5
16/07/2022 Sequoia BARUERI 11679,5
05/07/2022 Jadlog BARUERI 11168
18/07/2022 Jadlog BARUERI 10748
01/07/2022 Jadlog BARUERI 10458,5
25/07/2022 Jadlog BARUERI 10303
16/07/2022 Jadlog BARUERI 8562,5
04/07/2022 Jadlog BARUERI 8539,5
08/07/2022 Jadlog CAMPINAS 7364,5
12/07/2022 Jadlog CAMPINAS 5837,5
11/07/2022 Jadlog CAMPINAS 5678,5
08/07/2022 Sequoia CAMPINAS 5101
13/07/2022 Jadlog CAMPINAS 4245,5
07/07/2022 Jadlog CAMPINAS 4104,5
12/07/2022 Sequoia CAMPINAS 4069
11/07/2022 Sequoia CAMPINAS 3990,5
14/07/2022 Jadlog CAMPINAS 3501,5
15/07/2022 Jadlog CAMPINAS 3457
18/07/2022 Jadlog CAMPINAS 3396
19/07/2022 Jadlog CAMPINAS 3368,5
20/07/2022 Jadlog CAMPINAS 3344,5
21/07/2022 Jadlog CAMPINAS 3325
22/07/2022 Jadlog CAMPINAS 3309
23/07/2022 Jadlog CAMPINAS 3309
25/07/2022 Jadlog CAMPINAS 3280,5
26/07/2022 Jadlog CAMPINAS 3265,5
27/07/2022 Jadlog CAMPINAS 3254
28/07/2022 Jadlog CAMPINAS 3245,5
29/07/2022 Jadlog CAMPINAS 3239
06/07/2022 Jadlog CAMPINAS 3207
05/07/2022 Jadlog CAMPINAS 3205,5
01/07/2022 Jadlog CAMPINAS 3199
30/07/2022 Sequoia BARUERI 2963,5
13/07/2022 Sequoia CAMPINAS 2932
04/07/2022 Jadlog CAMPINAS 2898
07/07/2022 Sequoia CAMPINAS 2761,5
14/07/2022 Sequoia CAMPINAS 2403,5
15/07/2022 Sequoia CAMPINAS 2362
18/07/2022 Sequoia CAMPINAS 2305,5
19/07/2022 Sequoia CAMPINAS 2282
20/07/2022 Sequoia CAMPINAS 2263
21/07/2022 Sequoia CAMPINAS 2247,5
23/07/2022 Sequoia CAMPINAS 2234,5
22/07/2022 Sequoia CAMPINAS 2234,5
25/07/2022 Sequoia CAMPINAS 2212
26/07/2022 Sequoia CAMPINAS 2200
27/07/2022 Sequoia CAMPINAS 2191