cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kolumam Member
Member

Re: Issue with Calculated column

Hi All,

dadsa.JPGformula.JPG

 

 

 

 

 

 

 

 

 

The existing numbers changed to something else?

 

themistoklis New Contributor
New Contributor

Re: Issue with Calculated column

@Kolumam

Have you used the FORMAT formula like this?

 

FORMAT(ColumnName, "")

with double quotes at the end?

Kolumam Member
Member

Re: Issue with Calculated column

Hi 

 

Please find the formula.

 

Specific Water Usage (format) = FORMAT('Cleaning Activity'[Specific_Water_Usage__c], "string")

themistoklis New Contributor
New Contributor

Re: Issue with Calculated column

Change it to 

 

Specific Water Usage (format) = FORMAT('Cleaning Activity'[Specific_Water_Usage__c], "")

without the word 'string'

View solution in original post

Kolumam Member
Member

Re: Issue with Calculated column

Awesome, Thank you so much.

themistoklis New Contributor
New Contributor

Re: Issue with Calculated column

No problem@Kolumam 

 

If the answer provided has fixed your issue please mark is as a solution so as to help other readers as well.

 

Thanks

Kolumam Member
Member

Re: Issue with Calculated column

One last question,

 

Is there anyways to calculate the average totoal for the column if it consits of both NA and number?

Highlighted
Kolumam Member
Member

Re: Issue with Calculated column

Already marked as accept it as solution.

themistoklis New Contributor
New Contributor

Re: Issue with Calculated column

@Kolumam

 

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

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)