Solved: M Script Error in Script when column has blanks va...

WhaleWatcher222 · ‎02-06-2025

Hi Experts

Cannot see the error in my M Script when adding a custom column in Power Query

if [#"Forecasts-Actuals"] = "" and Date.Month(Date) = 4 then "Forecast - P01" else [#"Forecasts-Actuals"]

bhanu_gautam · ‎02-06-2025

if [#"Forecasts-Actuals"] = null or [#"Forecasts-Actuals"] = "" and Date.Month([Date]) = 4 then "Forecast - P01" else [#"Forecasts-Actuals"]

Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!

bhanu_gautam · ‎02-06-2025

if [#"Forecasts-Actuals"] = null or [#"Forecasts-Actuals"] = "" and Date.Month([Date]) = 4 then "Forecast - P01" else [#"Forecasts-Actuals"]

Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!

M Script Error in Script when column has blanks values