I have created a measure in Power BI Desktop that returns from a Decimal Day (i.e. 25.50) a Day, Hour, Minute etc (25 Days 12 Hours 0 Minutes). This works without issue.
When trying to use this measure in the 'Format String Expression' in Tabular Editor 2, I am getting some strange results whenever a Zero is returned anywhere in the whole number.
I have stripped it down to only asking Tabular Editor to return the Integer of the Decimal number and the problem remains.
As can been seen here, whenever the whole number 'part' of the decimal has a Zero (0) located anywhere in it the Selected Measure result is wrong. The right table should just be returning the integer of the left tables decimal number.
The measure on the left table is ...
ROUND(AVERAGE('Case Management'[Days to Resolution]),2)
This is the exact measure in the calculation group in the right table.
The format string expression for the calculation group is...
INT([Average Days To Resolution]) & "Days"
As can be seen below:
I have been going round in circles for sometime now.
Anyone know why this is or how to fix it?