Forum Discussion
Query Editor: IF Date < then empty
Hi, I never work with Query Editor much, so I'm not sure how to do this. I have a date field from a very old system, which doesn't know blank/null values. Meaning that if a date field is empty i...
I actually found a way because you made me think of it.
= Table.ReplaceValue(#"Replaced Value",#datetime(1753, 1, 1, 0, 0, 0),null,Replacer.ReplaceValue,{"ARCHIEF_DATUM"})
Hi Anonymous ,
Instead of making dates before 1900 blank , just filter the dates is after or equal to 01/01/1900 (assuming that dates before 1900 are not in use) in Power Query level. This will also decrease your refresh time.
I actually found a way because you made me think of it.
= Table.ReplaceValue(#"Replaced Value",#datetime(1753, 1, 1, 0, 0, 0),null,Replacer.ReplaceValue,{"ARCHIEF_DATUM"})
You can also refer to this link.