Forum Discussion
Divide row by row
Hi guys, I've been having a little problem doing some math. I have the following table Time Banana Apple 1300-1305 1000 50 1305-1310 2000 30 1310-1315 3000 10...
If the columns are differnt the how can we achieve this(2 columns are coming into 2 different tables)
You can use PowerQuery and "Unpivot" the different fruits into one column (Attribute), creating a new column of quantity (value). The Date will double up in each row, the same for Banana & Apple.
The basic of a proper table is one attribute per column (date, product, value, store, customer, ...).
Depending on the complexity of your model, you'll want to use dimension tables and link that to your fact table(s).