Forum Discussion

1001's avatar
1001
Resolver II
3 years ago
Solved

If statement for a percent value

Hi All, I have a calculated column (see below) to calculate a percent from two numbers of other columns. Now I'd like to create another column to display if the percent is greater than 70%. Just not...
Need Help
  • Migasuke's avatar
    Migasuke
    3 years ago

    Hi,

    In your DAX calculation do not use % sign, only use decimal version. Instead of 20% use 0.2 etc.
    Example here:

     

Migasuke's avatar
Migasuke
Memorable Member
3 years ago

Hi,

In your DAX calculation do not use % sign, only use decimal version. Instead of 20% use 0.2 etc.
Example here:

 

1001's avatar
1001
Resolver II
3 years ago

Ahh, I had .7 rather 0.7 earlier. 

Thanks Migasuke, appreciate that. Cheers.