Powerquery / M - create date column when celss are empty

[KristofferAJ]

Hi,

I have a set of data which "Country Start" and "Country End" dates per country
This data is connected to a Global daat set "with "Global Start" and "Global End" 

My country data is not always popualted with start end dates, and I would therefore like to use the Global Start/end for those?

How can I do this directly into powerquery?

Im thinking in the lines of this
NEW COLUMN= IF(Country Start)="",RELATED(Global START),(Country Start))

I hope this makes sense

KRistoffer

[BA_Pete · Accepted solution]

Hi @KristofferAJ ,

I think the simplest way in PQ would be to merge your Global start/end dates onto your Country table, then add a couple of new start/end date columns something like this:

countryStartDateFilled =
if [countryStartDate] = null then [globalStartDate] else [countryStartDate]

countryEndDateFilled =
if [countryEndDate] = null then [globalEndDate] else [countryEndDate]

Pete

[KristofferAJ]

Thanks, thats actually also what I realized