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.