how to get pivot table from excel into power bi

[Anonymous]

Hi All,

I have an Excel file with below pivot table, which is calculating data from different excel sheets. How do I get this same data in Power BI?

I want to develop this same table in Power BI which uses same calculations.

Eg: The below Total INC formula should be replicated in Power BI.

Thanks In Advance,

Neelofar.

[amitchandak]

@Anonymous , You have use  Matrix visual and create measures as per need

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.