I have some measures created in Power BI, which are KPIs ratings (related to a survey)
I have an Excel File, which contains a column "KPI ratings". I have calculated my KPI average into Power BI, is that possible to automatically extract the average from Power BI (which is a DAX measure) and insert the result into an Excel cell?
For instance, my DAX measure in Power BI is: "Quality ratings - 2022". I have a column in Excel, can we extract the name "Quality Ratings - 2022" and then fill a cell with the name? Finally extract the result, for instance in Power BI the ratings it's 75% (the result of the DAX function), and fill a cell in Excel with this result.