Forum Discussion
Solved
Data Modeling: Show dimensions side by side
Hi all, I need to make a report for our warehouse which will show the item in a given location along with the item and location dimensions. Location Location Height Location Width Loca...
I think the answer is to consolidate, i.e. flatten, dimension tables so the schema is star and not snowflake. Basically if a dimension table has a parent table there probably is a way to combine them to simplify the schema.
Hi b2wise ,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng