Forum Discussion
Kevincc
6 years agoNew Member
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
- mussaendaCommunity Champion
It can be possible if you will explain more.
Power BI is really powerful
- KevinccNew 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.
- amitchandakSuper User
Load the raw data and let us know what formula you needs with example.
- KevinccNew 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.