Excel: Create an automated KPIs template in 10 mins

[@syachrulamrief6115]

Thank you so much Mr. Mohamed

[@mohamedeladawiashour]

Thanks a lot for your feedback, you’re welcome

[@Riteshrai-q7f]

Great one . Keep it up and share some more related to optimization parameters

[@mohamedeladawiashour]

Thank you, sure

[@3zz79]

Impressive work 👏🏼👏🏼

[@mohamedeladawiashour]

Thank you 🙏

[@jeanclaudelionelnganyogo3528]

Very Insightful Mr Mohamed

[@mohamedeladawiashour]

Thank you

[@jeanclaudelionelnganyogo3528]

@@mohamedeladawiashour pls how to do a modification maybe in the column of the raw data

[@mohamedeladawiashour]

@jeanclaudelionelnganyogo3528 please refer to this video about power query Master Power BI Query Editor: Best Practical Practices kzbin.info/www/bejne/kKSuh6OlZd9-mZY

[@jeanclaudelionelnganyogo3528]

@@mohamedeladawiashour ok thanks..

[@rehant577]

thanks, its really fast...but the thing is i am unable to change the KPI type. like i want average of a KPI. its gives an error message. "we can't summarize this field with average because it's not a supported calculation for text data type".

[@mohamedeladawiashour]

Thanks, you can change it in the power query itself, just right click on the column and change the type to integer, refer to the below video kzbin.info/www/bejne/kKSuh6OlZd9-mZYsi=iV0hMULxMbibQDTg

[@sachinmuskawad3447]

👍

[@mohamedeladawiashour]

Thank you