Calculating Category/Brand Value Share

[Yrstruly2021]

I create the attached excel reports by doing tedious and repetative excercise everytime i want similar reports(export from powerbi dashboard).

I want to automate or make the process easier. Anybody have an idea how to replicate these reports in powerbi, please?

See data: https://drive.google.com/file/d/1HCoYlPrhBQKuvWb-TpOBbDBEnv0BV0Sj/view?usp=sharing

[Yrstruly2021]

Data in excel and ddl https://drive.google.com/drive/folders/1jUFHVlGZsHNdE6H0TuB2FI6c19Up52eR?usp=sharing 

[Anonymous]

@Yrstruly2021 

This should be dead easy in PBI 🙂 But to do such things you have to have the raw data (from which such reps are created) in the correct format (database table format). I'm at work at the moment but I'll have a look later if nobody else takes care of this. Can you please post the raw data from which the above are derived? If it's too much, then you can post a link to a file with the data... Or maybe the raw data is in the spreadsheet already?

[Yrstruly2021]

@Anonymous Have you had a chance to look at the data, any feedback?

@AntrikshSharma   @stevedep  Any insight guys?

[Yrstruly2021]

Thank you for assisting. Yes, it should be easy. But it's not.

See data: https://drive.google.com/file/d/1zqSbAvESHf5WUw4U-OKXjL_9E8NbJTfd/view?usp=sharing

I want to asnwer these questions: https://drive.google.com/file/d/1plg9Ocy2kJdM3sR2WpXY_uSiXRQbhUFN/view?usp=sharing