Forum Discussion

dbobonec's avatar
dbobonec
Frequent Visitor
5 years ago
Solved

Table with an explicit total column

Hi,   I'm struggling with the following problem: I need to create a table in Power BI Desktop that give me a measure value (let's say capital) by ContractType and Bank, as the example below, but I ...
Need Help
  • dbobonec's avatar
    dbobonec
    5 years ago

    Hi v-easonf-msft,

    Thank you very much for your reply, for what I see from your pbix it will work for my example.
    I need to adapt it to my real problem, with higher complexity, but I will accept it as a solution!

    Thank you and regards, Diogo 

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Is your data unpivoted (i.e., all bank names in same column)?  That is the recommended format but it can be done either way.  Do you plan to export from a matrix visual?  or are you going to copy out of data view or the query editor?

 

Regards,

Pat

dbobonec's avatar
dbobonec
Frequent Visitor
5 years ago

Hi mahoneypat,

Thank you for your reply.
Yes, all bank names are in the same column.

My goal is to export to a csv file from a matrix visual, using «export data» option.

Regards,

Diogo