Forum Discussion

Victormar's avatar
Victormar
Helper V
3 years ago
Solved

Creating new table adding a custom column to summarize

Hi again community, I've been trying for a while to create a new table from some existing columns that I have, but also adding a column manually, and I haven't been able too.  I have tried with s...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi Victormar ,

     

    Please try:

    Table = 
UNION (
    SUMMARIZECOLUMNS (
        'DIM_Chassis',
        "Name",("Mileage"),
        "OK", COUNT ( DIM_Chassis[c_MileageLateastIsDeviatedGreen] ),
        "Over", COUNT ( DIM_Chassis[c_MileageLateastIsDeviatedRed] ),
        "Below", COUNT ( DIM_Chassis[c_MileageLateastIsDeviatedYellow] )
    ),
    SUMMARIZECOLUMNS (
        'DIM_Chassis',
        "Name",("Speed"),
        "OK", COUNT ( DIM_Chassis[c_SpeedLateastIsDeviatedGreen] ),
        "Over", COUNT ( DIM_Chassis[c_SpeedLateastIsDeviatedRed] ),
        "Below", COUNT ( DIM_Chassis[c_SpeedLateastIsDeviatedYellow] )
    ),
    SUMMARIZECOLUMNS (
        'DIM_Chassis',
        "Name",("EnergyConsumption"),
        "OK", COUNT ( DIM_Chassis[c_EnergyConsumptionLateastIsDeviatedGreen] ),
        "Over", COUNT ( DIM_Chassis[c_EnergyConsumptionLateastIsDeviatedRed] ),
        "Below", COUNT ( DIM_Chassis[c_EnergyConsumptionLateastIsDeviatedYellow] )
    )
)

    Final output:

     

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Sharonsb's avatar
Sharonsb
Regular Visitor
3 years ago

Hi,

Please help with the following question:

 

I would like to have a new column by summarizing the rows from one column in the same table along with the corresponding . This is the table format 

Project  FY22 FY23 FY24 FY25
abc      100 200 300 400
def        500 600 700 800
ghi      900 100 200 300
jkl       400 500 600 700
mno   800 900 100 200

I would like to achieve the following :

FY22 FY23 FY24 FY25
abc+ghi+mno 1800 1200 600 900
def+jkl             900 1100 1300 1500