CODEWITHSUNDEEP
powerbipowerquerym
bidevkelly
bidevkelly

Reputation: 25

Replacing errors with blank on M/ Power BI Advanced query editor?

I have a simple formula that working great, but I want to replace any errors with blank. 

Can anybody please help me to change this?

= Table.AddColumn(#"Added Custom", "AnnualBacklog", each if [AnnualThr] < [TotalRemaining] then [AnnualThr] else [TotalRemaining])

Upvotes: 1

Views: 1255

Answers (1)

Ashok Anumula
Ashok Anumula

Reputation: 1515

#"XYZ" = Table.AddColumn(#"Added Custom", "AnnualBacklog", each if [AnnualThr] < [TotalRemaining] then [AnnualThr] else [TotalRemaining])

    #"Replaced Errors" = Table.ReplaceErrorValues(#"XYZ", {{"AnnualBacklog", ""}})
in
    #"Replaced Errors"

Upvotes: 1

Related Questions