topic Re: Converting in DAX Commands and Tips

Converting

Anonymous — Thu, 29 Jun 2023 11:38:48 GMT

Hello,

Could you please help with rounding the values :

Conditions:

KPI = 100% should be 100%

KPI >100% should be 100%

KPI Infinity = should be 0%

My dax: Rounding = IF(if('KPI'[KPI %]>1, 1, 'KPI'[KPI %]), if('KPI'[KPI %]<=1, 'KPI'[KPI %],0))

Eventually, KPI >100% should be 100% - not worked:

Re: Converting

SamInogic — Thu, 29 Jun 2023 12:22:47 GMT

Hi Anonymous ,

Can you try below DAX for rounding column?

Rounding = if('KPI Percentage'[KPI %]>1, 1, if('KPI Percentage'[KPI %]<=1, 'KPI Percentage'[KPI %],0))

Thanks!

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at crm@inogic.com

Services: http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/

Re: Converting

Anonymous — Fri, 30 Jun 2023 08:45:19 GMT

Thank you!

But the condition KPI Infinity = should be 0% did not work. If I don't have data for 2024 (Infinity), then it should show 0. Now it is - 100% Can you help?

Re: Converting

SamInogic — Fri, 30 Jun 2023 09:51:30 GMT

Hi Anonymous ,

Could you please try below DAX expression as this will check if the KPI value is less than or equal to 0 then it will round it to 0%.

Rounding = if('KPI Percentage'[KPI %]<=0,0, if('KPI Percentage'[KPI %]>1, 1, if('KPI Percentage'[KPI %]<=1, 'KPI Percentage'[KPI %],0)))

Thanks!

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at crm@inogic.com

Services: http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/