Forum Discussion

PVVBl00's avatar
PVVBl00
Helper III
4 years ago
Solved

Join values to single row

Hello everyone                                   I would like to know if in power BI there is any function or how I should do so that of these 3 columns I only leave the first one with the values of...
Need Help
  • bcdobbs's avatar
    bcdobbs
    4 years ago

    Try a calculated table:

    ADDCOLUMNS (

        SUMMARIZE (
            TableName[NUM ID],

            TableName[Type]
        ),

        "Col1", CALCULATE ( SUM ( TableName[1] ) ),

        "Col2", CALCULATE ( SUM ( TableName[2] )),

        "Col1+2", CALCULATE ( SUM ( TableName[1+2] ))

    )

     

    Alternatively you could use group by in power query.

     

bcdobbs's avatar
bcdobbs
Community Champion
4 years ago

Try a calculated table:

ADDCOLUMNS (

    SUMMARIZE (
        TableName[NUM ID],

        TableName[Type]
    ),

    "Col1", CALCULATE ( SUM ( TableName[1] ) ),

    "Col2", CALCULATE ( SUM ( TableName[2] )),

    "Col1+2", CALCULATE ( SUM ( TableName[1+2] ))

)

 

Alternatively you could use group by in power query.

 

  • PVVBl00's avatar
    PVVBl00
    Helper III
    4 years ago

    Everything works perfectly for me, thank you very much :)), but in the column of 1 + 2, the value of the sum brings me wrong, you have any idea why it should be?