Forum Discussion
Replace NULL with today's date
I have a table in Query Editor that is the result of a lookup for an end date scenario. What I'd like to do is replace the null values with today's date. I think I could create a calculated colu...
Figured this out.
- In Query Editor, select the column and use Replace Values from the Transform ribbon to replace "null" with "1/1/2019" (quotes not used the dialogue). Hit OK.
- In the Home ribbon, choose Query Editor and find the "Replaced Value" line just created. Power BI will have interpreted 1/1/2019 as #datetime(2019, 1, 1, 0, 0, 0). Replace that string with DateTime.LocalNow() and hit Done.
mussaenda
Community Champion
Community ChampionReplaceDate = IF (DateTable[Date] = blank(), today(), DateTable[Date])
this is in dax. If you don't want to add another column, you may take a look at forum
carlosagarciaHelper I
Worked like a charm.