Forum Discussion

hksl's avatar
hksl
Icon for Helper I rankHelper I
10 years ago

Retrieve result when tables related by combination key (two columns)

I am a beginner. Power Bi Desktop free version. Creating table visualization. I have following tables:   Table1:  C1 , C2, C3        1      2    a 1      3    g 2      2    c 2      3    h  ...
Need Help
v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

hksl

 

Do you want to get the sum result for the combinations in Table1 as below?

 

 

Best Regards,

Herbert

hksl's avatar
hksl
Icon for Helper I rankHelper I
10 years ago

Yes I need that sum too. . .

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    hksl

     

    To get the sum, have you tried to create a calculated column with the formula in my screenshot?

    And do you want to get any other result except this result?

     

    Best Regards,

    Herbert