Forum Discussion
Building my data correctly in Excel
Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
- Anonymous6 years agoNot applicable
Thank you for the feedback. I have attached 2 screenshots below:
The first one is from a tutorial video while the second one is my screen. In the first screenshot, under the fields section, you can see that the datasets are arranged into different tables making it possible to make different selections under a table. How can I achieve this?
How do I organize my data so it can reflect in the same way
- v-zhenbw-msft6 years agoCommunity Support
Hi Anonymous ,
If you want to create some tables based on your SAP table, you need to download Power BI Desktop and use the create a New table function.
When you finish downloading, you can get data from your data source and create some tables based on your business logic.
You can refer the following articles.
https://www.tutorialspoint.com/power_bi/power_bi_data_modeling.htm
https://radacad.com/creating-a-table-in-power-bi-using-dax-table-constructor
https://databear.com/dax-table-functions-part-1/
If you have any question, please kindly ask here and we will try to resolve it.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.