Hi everyone. Have come across with a measure which I need to replicate but I don't know how. What sort of calcuation is the attached?
Go to Solution.
This is a Key Performance Indicators (KPIs) in Power Pivot.
Please refer to below steps to replicate this KPI in your .pbix file.
1.Create a PowerPivot data model.
1) Create some sample data in Excel worksheet. Add it to Table.
2) Add table to Data Model
3) In PowerPivot, create a simple measure, then, create KPI based on this measure. Save all these changes.
4) In worksheet, create a table visual, add above measure into visual.
2. Import above PowerPivot model into Power BI desktop. (File->Import->Excel workbook contents)
Reference: Create a KPI in Power Pivot for Excel – Tutorial
View solution in original post
It's a KPI. Key Performance Indicator.
This is a pretty good intro to how KPIs work: https://www.sqlchick.com/entries/2010/10/10/display-of-ssas-kpi-indicators-in-excel.html
Thanks @freder1ck will take a look
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.