Forum Discussion
Get value from date slider(slicer)
- 6 years ago
Hi Foolke ,
Please delete the'.[Date]' in your measure, it will transfer a larger built-in date table in power bi so that you will get the wrong date value.
Min date = CALCULATE ( MIN ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar' ) )Max Date = CALCULATE ( MAX ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar' ) )Selected date = "selected date:" & [Min date] & "-" & [Max Date]You will get the right result:
Also, you can only create single measure by using variance to get the same result:
Measure = var _mindate = CALCULATE(MIN('Calendar'[Date]),ALLSELECTED('Calendar')) var _maxdate = CALCULATE(MAX('Calendar'[Date]),ALLSELECTED('Calendar')) return "Selected date:" & _mindate & "-" & _maxdateBest Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi Foolke ,
Please delete the'.[Date]' in your measure, it will transfer a larger built-in date table in power bi so that you will get the wrong date value.
Min date =
CALCULATE ( MIN ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar' ) )Max Date =
CALCULATE ( MAX ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar' ) )Selected date = "selected date:" & [Min date] & "-" & [Max Date]You will get the right result:
Also, you can only create single measure by using variance to get the same result:
Measure =
var _mindate = CALCULATE(MIN('Calendar'[Date]),ALLSELECTED('Calendar'))
var _maxdate = CALCULATE(MAX('Calendar'[Date]),ALLSELECTED('Calendar'))
return
"Selected date:" & _mindate & "-" & _maxdate
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.