i would like to replace Null values with today’s date.
i have table with effective_day_date and Expiry_day_date. Expiry_day_date has Null values and i would like to replace null with today’s date.
Effective_day_date has: jan2009 and jan2019
Expiry_day_date has : dec2018.
what explains this is product from jan2009- dec 2018 is effective and 2019 jan will be expiry or in effective.
if user select calendar date slicer may 2009 - dec2018 still it should show effective dates data but it’s not showing. so what am trying to do is transform those dates into a number and the create a list or sequence of numbers based on that effective date and expiry date. since expiry date fields having Null values i need to replace that with Today’s date or any future date and then i can use that custom column to join with date dimension table.
this is all my theory but in order to do that i need to know how to replace null with today date? ’
any thoughts or suggestions is much appreciated.
Batch Routes_test.pbix (302.7 KB)