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 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

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] )

     

4 Replies

  • 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] )

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

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