Forum Discussion

Dhjlm's avatar
Dhjlm
Frequent Visitor
5 years ago
Solved

Need help with summarizedcolumns

I have a table that look like this:     I want a new table with this result:     Any suggestions?    
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Dhjlm ，

    You can create a calculated table as below:

     

    sTable =
SUMMARIZECOLUMNS (
    'Table'[Sales],
    "Monday", SUM ( 'Table'[Monday] ),
    "Tuesday", SUM ( 'Table'[Tuesday] ),
    "Wednesday", SUM ( 'Table'[Wednesday] ),
    "Thursday", SUM ( 'Table'[Thursday] ),
    "Friday", SUM ( 'Table'[Friday] )
)

     

    But I have one doubt, why didn't you create a table visual directly without creating any measure or calculated table just like below screenshot? 

     

    Best Regards

ibarrau's avatar
ibarrau
Super User
5 years ago

Hi. Can you specify a bit more about it? it doesn't make any sense the request. If you want that on a Power Bi Visualization, just add a matrix/table and add the values. Power Bi aggregates values automatically and it will group by non numerical columns like "Sales 1".

If you have a data sorce that you want to transform for your data model you can do it in the Transform Data menú like this:

 

Please explain more about it so we can help you.

Hope the message helps,