Forum Discussion

RMV's avatar
RMV
Helper V
9 years ago
Solved

combining data

Hi,   I have a formula to combine 2 tables Table 1. Date           Category            Additional Category       Qty 1-Jan-17       A                        Add-1                           10 1...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi RMV,

     

    It seems your formula is incomplete. I created a new one. Would you like to try it?

     

    Table 2 =
SUMMARIZE (
    'Table1',
    Table1[Category],
    "Value", IF (
        'Table1'[Category] = "C",
        CALCULATE (
            SUM ( Table1[QTY] ),
            FILTER (
                ALL ( 'Table1' ),
                'Table1'[Category] = "C"
                    || 'Table1'[Additional Category] = "Add-1"
            )
        ),
        SUM ( Table1[QTY] )
    )
)

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

Hi RMV,

 

It seems your formula is incomplete. I created a new one. Would you like to try it?

 

Table 2 =
SUMMARIZE (
    'Table1',
    Table1[Category],
    "Value", IF (
        'Table1'[Category] = "C",
        CALCULATE (
            SUM ( Table1[QTY] ),
            FILTER (
                ALL ( 'Table1' ),
                'Table1'[Category] = "C"
                    || 'Table1'[Additional Category] = "Add-1"
            )
        ),
        SUM ( Table1[QTY] )
    )
)

 

 

 

 

 

 

 

 

Best Regards!

Dale

RMV's avatar
RMV
Helper V
9 years ago

Hi v-jiascu-msft, thanks for the help.