Hello Expert
I am trying to convert by large excel files into Power BI data sets and I have a question on Data Management. I currently have all my data (Sales, COGS, Assets liabilites, Operating expenses, customers, vendors, products, departments) in one large data table and various small look up tables. Should i break up the large table into say - P&L, BalanceSheet or break it down further - say Revenue Table, cost Table, Opex Table.
I also have the forecast/actual/budget also in the same table...see my columns below
| Account | Department | Product | MonthEnd | CustomerId | Scenario | Amount |
The reason is ask is....can i create a measure for Gross profit from one large table or do i create different tables for Revenue and COGS and merge them. This also kind of helps me to stop the interaction and leave a chart alone and add another chart with out affecting the first one. For example I want to show - Gross Profit for the entire company in a Card and Sales for only one division in another card. Getting this seems impossible to me in Power BI
Thanks and appreciate anybody having patience to go through my question.
