Get the Start and End Date from a slicer based on a field not part of Date Table

[DarshG]

Hi,

I have a date field called DTime in a Transactions table. I want to get the Start and End Date selected in the slicer on this DTime field. I already tried MIN/ MAX but it shows the oldest and latest date in the DTime column and not the Start and End from the slicer.

e.g. Date Selected in Slicer: 4/1/2024 - 9/30/2024

Value extracted using CALCULATE/ MIN/ MAX = 1/1/1990 - 12/31/2024

Expected Output: 4/1/2024 - 9/30/2024

[Anonymous]

Hi @DarshG ,

You need to use the unrelated date table for the extraction because the related date table will filter the data table, and since the date table is continuous, it will return the original data when it is not included in the date you are filtering.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[ToddChitt]

I think you need the SELECTEDVALUE function, then because that could be multiple dates in the slicer, wrap that in MIN and MAX functions.

But really, I am not 100% sure of what you are trying to accomplish here. Can you supply some sample data points, with desired output?