How to capture the filtered DATE value for further analytics

[GPetroff]

Hi All,

I do have a dashboard with a date filter.

I need to take the user selected beg date and end date to manipulate/transform one complex table.

Question: is there an easy way to refer to the existing filter/slicer object and use that dates when building new queries?

Thank you.

Sincerely

George

[GPetroff]

Hi Johnt75,

This is a great step. I used Record.Field(Table.Min(#"dateTable","DateField"),"DateField") and I am getting the min value from the date table, however, not the minimum selected date value. 

[johnt75 · Accepted solution]

That's Power Query, you won't be able to get anything from the slicers in that, you'll need to use DAX. At the time power query is run, during data load, the slicers basically don't exist so there will be no selections made

[GPetroff]

Thank you for xplaining the logic

[johnt75]

You can use MIN('Date'[Date]) and MAX('Date'[Date]) to get the values.