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

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
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

12Bowers12's avatar
12Bowers12
Icon for Helper V rankHelper V
7 years ago

Very helpful.

Is it possible to diectly to put the new table into Report as a Visualization Table?

Thank you.

Dennis