- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Load the raw data and let us know what formula you needs with example.
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
Online Event
Register Here
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It can be possible if you will explain more.
Power BI is really powerful
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
07-22-2023 01:23 PM | |||
Anonymous
| 03-17-2020 07:34 AM | ||
05-22-2024 11:46 AM | |||
12-11-2023 11:36 PM | |||
10-13-2023 01:02 PM |
User | Count |
---|---|
119 | |
73 | |
57 | |
57 | |
43 |
User | Count |
---|---|
177 | |
120 | |
82 | |
68 | |
57 |