Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Just drag [Date] from a disconnected calendar table to Slicer, and use MIN function.
MIN ( 'Calendar'[Date] )
declare @date datetime; set @date = null
--declare @date datetime; set @date = '2015-01-01'
select coalesce( convert( varchar(10), @date, 103 ), '')
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.
Thanks for the quick response.
With out updating column, Can we create measure with same condition ?
for Ex:
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |