Forum Discussion
Jalal_1988
Nov 05, 2023Brass Contributor
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 i...
SergeiBaklan
Nov 06, 2023Diamond 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_1988
Nov 06, 2023Brass 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
- SergeiBaklanNov 06, 2023Diamond 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.