Forum Discussion

Hesham's avatar
Hesham
Frequent Visitor
8 years ago
Solved

Summarize table and add new column

Hi all i am new in Power BI so, i stopped in few Issues the most important one is: I have huge data table as below: (Details table)   The point i need to Summarize table and add new column ba...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Hesham,

     

    Create a calculated table using below formula:

    Summarize Table =
ADDCOLUMNS (
    SUMMARIZE (
        Sheet1,
        Sheet1[Cus Phone],
        "Total order", DISTINCTCOUNT ( Sheet1[Order_num] ),
        "Total revenue", SUM ( Sheet1[Item_Rev] )
    ),
    "Flag", IF ( [Total order] <= 2, "Light", IF ( [Total order] >= 5, "High", "Medium" ) )
)

     

    By the way, please mask sensitive data before uploading.

     

    Best regards,
    Yuliana Gu

rocky09's avatar
rocky09
Icon for Solution Sage rankSolution Sage
8 years ago

Select Summary Table --> Select Custom Column and then use this.

 

Flag = SWITCH(TRUE(),
            SummaryTable[Total Orders]>= 5,"High",
            SummaryTable[Total Orders]<=2,"Light",
            SummaryTable[Total Orders]>=3 && SummaryTable[Total Orders]<5,"Medium")