How to not have "Null" considered a "0"

[szub]

Hello,

I am creating metrics for days between an arrival date and repair date.  If "0" is the value, we consider this as a "Same Day" repair. My issue is not all of my company branches record arrival and repair date, only the repair, so the value between the arrival and repair is "null" in PBI because it is blank on the uploaded spreadsheet.  When calculating the percentage of work done on the same day compared to all claims for all work done by a servicer, I am getting 100% for the branches that do not record both dates.  I have tried searching for a away to do this and only find how to have "null" populated with zeros, which I do not want to do or other methods that are not applicable.

I appreciate any assistance.

Thank you!

[Nathaniel_C · Accepted solution]

@szub ,

Maybe try ISBLANK() in your formula with an IF

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[szub]

@Nathaniel_C Thank you! That worked!

[ChrisMendoza]

@szub -

Something like this should replace null with a 0 value.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WstQ3stA3MjC0VNJRUorVAQtYwgQMDaBCxgYINbEA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Date = _t, Value = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Value", Int64.Type}}),
    Custom1 = Table.ReplaceValue(#"Changed Type",null,0,Replacer.ReplaceValue,Table.ColumnNames(#"Changed Type"))
in
    Custom1

[szub]

@ChrisMendoza Thank you for the reply, but counting null as zero is what I am trying to avoid.