Palani Manchikanti on 09 Feb 2022 11:43:35
When we use FORMAT function in Power BI, it does not consider the complete value unless the value is shown up to certain decimal points.
Ex: Query - 0 decimals FORMAT variance = FORMAT ( [Variance] , "+0%;-0%" )
Current =891
Base=894
delta =[Current]-[base]
variance = Divide([delta],[base])
Results is showing “+0%” format which is wrong and it need be shown as “-0%” as correct format.
For example, if a value of -0.003 is used and when using FORMAT function as shown above, the resultant value shows +0%.
This needs to be shown as -0%.
This does not change to +0% unless the resultant value is set with decimal points.
It would be great if this can be fixed in future releases.