User Selected Date Variables in Measure

[YellowDog]

I've got this measure that works as expected, but I want the users to be able to pick the desired start and end dates and have those selections dropped into the appropriate variables.  How would I do this?  Is there a date picker or something that can be utilized?

Fiscal Charges =

VAR StartDate = DATE(2021,1,1)

VAR EndDate = DATE(2021,4,2)

RETURN

SUMX(qryCharges,

IF([correction] = "N", [Total Charges],

IF([correction] = "Y" && [postingdate] < StartDate, -[Total Charges],

IF([correction]="Y" && [backoutdate] > EndDate, [Total Charges],

0) ) ) )

[selimovd · Accepted solution]

Hey @YellowDog ,

sure, you can just use a slicer with your date column.

In the measure you would have to change the variables to MIN(dateTable[Date]) and MIN(dateTable[Date]).

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[YellowDog]

I think I got it.  I created a date table and left it disconnected.  Then I could create the date slicer which gives me a decent user interface to select the beginning and end dates.  Works great, thanks!