Forum Discussion

Nivas538's avatar
Nivas538
Microsoft Employee
6 years ago
Solved

How do we update blank values with selected date value

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 ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    Nivas538 

     

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

    MIN ( 'Calendar'[Date] )

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

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's avatar
Nivas538
Microsoft Employee
6 years ago

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's avatar
    v-chuncz-msft
    Community Support
    6 years ago

    Nivas538 

     

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

    MIN ( 'Calendar'[Date] )