Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |