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.
Hi, Angith_Nair, thanks for the input. But I can't do that. I need the data that it's connected to. The frontend software of the database does not show 1753 but shows the date as not filled. I want to replicate that in my table by making the date blank 🙂