I’m just starting with Power BI and I want to split a spreadsheet which contains both sales and the bill of material for the item sold. Ideally I would get lookup tables containing the products, ingredients, recipes with a fact table of sales.
In working through the intro to PowerBI and DAX on this site I came across the filtered table. Is this the best approach for this kind of problem, or is there a better way to do the transformation of this data?
Just looking for a suggestion where to look so that I can try different methods.
@mpchean ,
I would definitely recommend you take a look at the lecture and materials for our Power BI Accelerator initiative, Week #2. The whole focus of that particular cycle were the best practices for transforming large flat files into star schema data models optimized for Power BI.
I think that will get you where you need to go, but if you still have questions after watching the lecture and the solution walkthrough, just give a shout.
I hope this is helpful.
- Brian
1 Like