Forum Discussion
POWER BI CHALLENGE
Hello My Friends
Kindly in attached Zip file you can find two Excel and power bi files,
Is there any one to move the Pivot table formula in excel file to Power Bi ?, I have done some steps in power Bi , Please notice that in Excel file we extract statements for one costumer, but in Power BI we want for all costumers,
Thank you my friends,
4 Replies
- SergeiBaklanDiamond Contributor
Do you mean to move data model from Excel to Power BI? In case as first thing they shall to have the same source. Fields in PQ_TableGrid are different on both files.
- Jalal_1988Brass Contributor
SergeiBaklan
My friend yes I mean Data model in power Bi, Yes the Data are different in Excel file we have one costumer, But in Power BI we have number of Costumers,
I need the Power Bi file like Excel which work correctly for each costumer,
Thank you- SergeiBaklanDiamond Contributor
You have different set of fields. In Excel
and in PBD
Thus we may repeat only first two measures. They are in the attached pbx file.
- Vinod2406Brass Contributor
Jalal_1988 Hi Jalal,
Small change I did to the excel right click on pivot year --> field setting --> Layout & Print --> tick on Repeat item labels
then upload to Power BI