topic Re: How to get selected date from slicer in DAX Commands and Tips

How to get selected date from slicer

LotteLaugesen — Mon, 18 Jul 2022 07:29:52 GMT

How can I get the selected date from a date slicer?
I have tried this:
Test MaxDate = SELECTEDVALUE(Dim_Calendar[Date]) (Returns blank)
Test MaxDate = MAX(Dim_Calendar[Date])

Test MaxDate = CALCULATE(MAX(Dim_Calendar[Date]),ALLSELECTED(Dim_Calendar[Date]))

The 2 last returns the last date in Dim_Calendar (31/12/2029) and not the selected date.

Can anybody help?

BR

Lotte

Re: How to get selected date from slicer

SpartaBI — Mon, 18 Jul 2022 07:35:00 GMT

LotteLaugesen how did you configure the slicer? Dates greater then?

What do you get when you write:

Test MinDate = MIN(Dim_Calendar[Date])

Re: How to get selected date from slicer

LotteLaugesen — Mon, 18 Jul 2022 07:38:17 GMT

SpartaBI
The slicer is Dates before
When I change it to Test MinDate = MIN(Dim_Calendar[Date]) I get 1/1/1900

Re: How to get selected date from slicer

SpartaBI — Mon, 18 Jul 2022 07:40:14 GMT

Can you share the file (leave just the relevant columna with dates)

Re: How to get selected date from slicer

LotteLaugesen — Mon, 18 Jul 2022 07:46:55 GMT

Thank you for asking - because now I found the problem. 😉

The calendar was related to another table with relationship both

Re: How to get selected date from slicer

SpartaBI — Mon, 18 Jul 2022 07:48:42 GMT

LotteLaugesen great, will appreciate your kudos 😉

Re: How to get selected date from slicer

LotteLaugesen — Mon, 18 Jul 2022 07:56:58 GMT

SpartaBI yes I will, but I found out it wasn't the whole truth.
I removed the relation a test solution and it worked, but when I did it the real solution it went back to 31/12/2029 😣

Re: How to get selected date from slicer

SpartaBI — Mon, 18 Jul 2022 08:00:22 GMT

LotteLaugesen will pm you now

Re: How to get selected date from slicer

Anonymous — Thu, 21 Jul 2022 03:25:49 GMT

Hi LotteLaugesen ,

Have you solved the issue now? If so, please mark the solution as the answer. If not, please provide more details with your desired output and pbix file without privacy information.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: How to get selected date from slicer

vapid128 — Thu, 21 Jul 2022 05:08:27 GMT

That is not normal.

I use MaxDate = MAX(Dim_Calendar[Date]) a lot.

The only case i can think how this happen is:

you have 2 tables with date. One end at 2029 and the other one end at 2022.

When your filter at the last of the one end with 2022.

It doesn't main you have a filter at a day in 2022.

It means you have no filter.

Or check you relationship, the cross filter direction need to be both.