Hi,
I'm pretty new to Excel 2010 Powerpivot add-in hence this question, bear with me please. I have 4 big files saved as .txt which contains the same exact fields. When I import them to Powerpivot, they are then placed on 4 separate tables. I would like to create an overview of the total performance of all 4 via a dynamic dashboard wherein the user will be able to choose either the total or individual performance based on slicers.
Ex.
filename = File1.txt
type = A product
fields = month, agent, revenue, count of sold products
filename - File2.txt
type = B product
fields = month, agent, revenue, count of sold products
filename - File3.txt
type = C product
fields = month, agent, revenue, count of sold products
required output:
slicer: Type (product), agent, month
data to be shown: total revenue, total count of sold products
i tried creating a relationship between them but it's saying that it must not contain duplicate values. B product contains data from Jan-Sep so there will be a repetition of agents showing up on the data.
i cannot copy-paste the values of each table to excel as they exceed 1.6M rows.
appreciate your assistance in clarifying this as i am a little confused with relationships.
Thank you so much in advance Power BI gods!
Regards,
Anatawan
I'm pretty new to Excel 2010 Powerpivot add-in hence this question, bear with me please. I have 4 big files saved as .txt which contains the same exact fields. When I import them to Powerpivot, they are then placed on 4 separate tables. I would like to create an overview of the total performance of all 4 via a dynamic dashboard wherein the user will be able to choose either the total or individual performance based on slicers.
Ex.
filename = File1.txt
type = A product
fields = month, agent, revenue, count of sold products
filename - File2.txt
type = B product
fields = month, agent, revenue, count of sold products
filename - File3.txt
type = C product
fields = month, agent, revenue, count of sold products
required output:
slicer: Type (product), agent, month
data to be shown: total revenue, total count of sold products
i tried creating a relationship between them but it's saying that it must not contain duplicate values. B product contains data from Jan-Sep so there will be a repetition of agents showing up on the data.
i cannot copy-paste the values of each table to excel as they exceed 1.6M rows.
appreciate your assistance in clarifying this as i am a little confused with relationships.
Thank you so much in advance Power BI gods!
Regards,
Anatawan