Search code examples
powerbipowerquerym

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])

Solution

  • #"XYZ" = Table.AddColumn(#"Added Custom", "AnnualBacklog", each if [AnnualThr] < [TotalRemaining] then [AnnualThr] else [TotalRemaining])
    
        #"Replaced Errors" = Table.ReplaceErrorValues(#"XYZ", {{"AnnualBacklog", ""}})
    in
        #"Replaced Errors"