The existing numbers changed to something else?
Have you used the FORMAT formula like this?
with double quotes at the end?
Please find the formula.
Specific Water Usage (format) = FORMAT('Cleaning Activity'[Specific_Water_Usage__c], "string")
Change it to
Specific Water Usage (format) = FORMAT('Cleaning Activity'[Specific_Water_Usage__c], "")
without the word 'string'
Awesome, Thank you so much.
If the answer provided has fixed your issue please mark is as a solution so as to help other readers as well.
One last question,
Is there anyways to calculate the average totoal for the column if it consits of both NA and number?
Already marked as accept it as solution.
There may be a way to do it that but you need to try it yourself.
I think you need to write a DAX formulas where
1. All values in the column will be first converted to numbers (blanks, NAs, NULLs converted to Zeros)
2. Then Put the FORMAT function at the end, which will take all the results (numbers) and convert them to text.
So the DAX will start with FORMAT ( transformation to number ) and will have the transformation within it.
I hope this makes sense?
You can give it a try and see if it works
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.