Nov 18 2022 01:52 AM
Hello Everyone,
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.
Thank you for your help, and have a nice day!
Nov 19 2022 05:17 AM
Depends o your subscription. You may connect to dataset from Data->Get Data->From Power Platform->From Power BI and use dataset measure with CUBE formulae.