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

     

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 ), '')