Help With Replicating Excel KPI Function in PowerBi

[qsmith83]

Hi,

I have an existing Excel function that I would like to replicate in PowerBi. The function calculates the RAG status of multiple metrics/kpi's based on parameters (essentially weightings) to return the RAG color based on those parameters.

I've replicated the metrics and RAG colors for each metric in PowerBi but I need help on how to calculate the RAG Status that was used in Excel. 

I hope that makes sense. Attached screenshots and files for reference.

Appreciate any help @tamerj1  @SpartaBI @johnt75 @Jihwan_Kim 

Excel version:

https://docs.google.com/spreadsheets/d/1kF5ABNd3WWAPfLdlmvsvaVhbYQQ7jacd/edit?usp=sharing&ouid=10626...

Pbix version:

https://drive.google.com/file/d/1EophB1pcV93xEqlckI9UVAluwl4_ok6R/view?usp=sharing

[v-jayw-msft]

Hi @qsmith83 ,

Have trouble to follow. According to the screenshot, the Columns in excel do not correspond to columns in Power BI, please share more details.

Best Regards,

Jay

[qsmith83 · Accepted solution]

Hi @v-jayw-msft , thanks for responding. My mistake for the discrepancies. But it's ok as I've managed to find a solution to my problem:)