Replace Parameter input in Power BI with Power App

[Syndicate_Admin]

My Power BI report is linked to an excel file file, with 2 columns A & B.

At Power BI,  A1 & B1 are parameters.

Parameter A1 & B1 are also used in calculation,

New Average of A = (SUM(Table1[A])+A1[A1 Value])/(COUNTA(Table1[A])+1);

New Average of B = (SUM(Table1[B])+B1[B1 Value])/(COUNTA(Table1[B])+1)

How can I use Power App to replace the parameter A1 & B1?

Appreciate any help. Please find the excel and PBIX file as attached.

[Syndicate_Admin · Accepted solution]

solved