How do we update blank values with selected date value

[Nivas538]

Hi All,

Wanted to update blank values in Date column with Selected value (Minimum Value: 08-08-2019 ) Dynamically ?

Date Slicer

For ex: 

1. Above slicer is the Date slicer with Between values , When change date in the slicer like as above snap , need to update blank value with minium value selected (Ex: 08-08-2019) in the slicer

                 and the same way if we change the date slicer like below  need to update blank value with minium value selected (Ex: 02-09-2020) in the slicer

thanks,

Sri

[Anonymous]

declare @date datetime; set @date = null
--declare @date datetime; set @date = '2015-01-01'

select coalesce( convert( varchar(10), @date, 103 ), '')

[Greg_Deckler]

If you are truly trying to update a column this will not work. Columns are static, calculated at the time of data refresh. Columns are not dynamic like measures. Thus, you can never have a measure update a column on the fly (dynamically). Only at refresh.

[Nivas538]

Thanks for the quick response. 

With out updating column, Can we create measure with same condition  ? 

for Ex: 

S_date_Measure  = IF(SELECTEDVALUERegistration[StartDate],MIN(Registration[StartDate]))=BLANK(),1,2)

Instead of 1 we need selected value from slicer

Thanks,

Sri

[v-chuncz-msft · Accepted solution]

@Nivas538 

Just drag [Date] from a disconnected calendar table to Slicer, and use MIN function.

MIN ( 'Calendar'[Date] )