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.
- Kevincc6 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.