Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I´m curious about this scenario; we have two .CSV files listing all 'OrderID, Date, Value, Customer Name' for product and another .CSV file with same fields but for services.
>>>We would like to compare wether in 2015 we sell more Products or Services (for year 2016 and 2017 also).
Should we create a third table to mix values and create on it a new colun to specify when it was 'Services' and when it was 'Product'?? Or there is another way to compare them?
Hey there,
it depends. if you have the same Columns and metadata in both tables you can append them and add some kine of Type Column.
Or you can create two fact tables with same dimension tables belonging to them.
Greetings.
Hi WolfBiber,
tks for quick reply, the data on .CSV is the same but for Services table we should 'split' a collumn for sales ID on '02' new columns because we have 02 information on only one field. Another point is that the original column came from .CSV with a 'text' so we createad a new one column with Dax function to ignore it:
RIGHT('Table-Services'[RPS_Original];LEN('Table-Services'[RPS_Original])-4)
Can you explain a little bit about:
Or you can create two fact tables with same dimension tables belonging to them.
hey, without seeing your data its hard to say which of them is the best way.
for your question:
You can have several Fact Tables with dimension linked to all of them.
Please find further information in tutorials of Power Bi and Star Schema (Snowflake Schema)
or google for "multiple fact tables in power bi".
Tks WolfBiber,
it was a "north" to me, I'll check.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |