Forum Discussion
1001
Resolver II
Resolver IIIf 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 sure how to write the DAX for it, if someone could help. Thanks.
Greater 70% = if('ZSLED Excel'[Percent Remaining]>70%,'ZSLED Excel'[Percent Remaining],0)
Hi,
In your DAX calculation do not use % sign, only use decimal version. Instead of 20% use 0.2 etc.
Example here:
