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?
amitchandak
6 years agoSuper User
Load the raw data and let us know what formula you needs with example.
Kevincc
6 years agoNew 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.