import customized table from excel

[Kevincc]

Hi All,

I have a table as attached. Each cell is driven by specific formulas in excel, is there a way to do the same in power bi?

[amitchandak]

Load the raw data and let us know what formula you needs with example.

[Kevincc]

The catgories (Sales, Selling Expenses etc) were manually typed in excel, then the formula used was mainly SUMIFs to get the financial data into the conrespondent cells. 

[mussaenda]

@Kevincc 

You will need raw data to start with.

Just like what you did in excel.

Once your raw data are loaded, you will start to calculate depending on your needs.

[mussaenda]

It can be possible if you will explain more.

Power BI is really powerful

[Kevincc]

The catgories (Sales, Selling Expenses etc) were manually typed in excel, then the formula used was mainly SUMIFs to get the financial data into the conrespondent cells.