I’ve got a table of data with the column Days in Arrears, this starts at 0 and increases.
There are however fields that contain null which must be left as is.
I’ve created a custom column in power query with the following M-Code, but the null is being categorized under "In Arrears" which I don’t want.
Is there anything that I can add to this syntax that will achieve what I am looking for?
if [Days In Arrears] = 0 then "No Arrears" else "In Arrears")
Expand your code to handle
null cases in your
Days In Arrears column. In clear text, just nest an
if then else that picks up
if [Days In Arrears] = null then null else if [Days In Arrears] = 0 then "No Arrears" else "In Arrears"
then null with whatever you want to display.