I wrote a formula to show NA if it is blank and if the date is below 31/3/2018, but I am getting the error
Expressions that yield variant data-type cannot be used to define calculated columns.
Specific Water Usage (litres/kWp) =
Can you please tell me how to put it in another way?
Go to Solution.
Change it to
Specific Water Usage (format) = FORMAT('Cleaning Activity'[Specific_Water_Usage__c], "")
without the word 'string'
try to return blank in place of 'NA'
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Still the same error.
I am trying to make the blank values to appear as NA. Please check my formula.
You can't have conflicting data types for the same column, in your case I am assuming it would Strings and Numbers
How to fix this?
Does it have to be strictly NA?
Why dont you put 0 instead of NA?
If it is 0, people would think no water has been used.
If it's NA, then pweople don't have to poulate it?
Any other work around please?
In case of no Water Usage it is best practice to just use 0. At most you could leave it blank
On PowerBI you cant have 2 different datatype on the same column. @LivioLanzo also mentioned that.
So you have 2 options.
You either convert numbers to text or text to numbers. If you dont want to NAs to be zeros then you can convert numbers to text.
The thing is blank doesn't mean that it's really blank.
People are not filling it.
The filter Cleaning Date < 31/8/2018 will apply to the water usage if it's blank and assign NA. For the dates after 31/8/2018, if it's blank people have to fill in.
That's the reason.
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.