Forum Discussion

Kevincc's avatar
Kevincc
New Member
6 years ago

import customized table from excel

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?

 

 

5 Replies

  • mussaenda's avatar
    mussaenda
    Community Champion

    It can be possible if you will explain more.

    Power BI is really powerful

    • Kevincc's avatar
      Kevincc
      New Member

      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.

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

    • Kevincc's avatar
      Kevincc
      New Member

      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's avatar
        mussaenda
        Community Champion

        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.