Forum Discussion

Nivas538's avatar
Nivas538
Icon for Microsoft Employee rankMicrosoft 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
Icon for Community Champion rankCommunity 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
    Icon for Microsoft Employee rankMicrosoft 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
      Icon for Community Support rankCommunity Support
      6 years ago

      Nivas538 

       

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

      MIN ( 'Calendar'[Date] )