Dynamic date parameters?

[rmcgrath]

Hello.  I would like to modify the following code snippet to refer to (2) cells in an Excel workbook (a cell for a start date and a cell for an end date)

VAR __DS0FilterTable5 = 

FILTER(

KEEPFILTERS(VALUES('Date Dim'[FiscalBaseDate])),

AND(

'Date Dim'[FiscalBaseDate] >= DATE(2024, 1, 1),

'Date Dim'[FiscalBaseDate] < DATE(2024, 2, 15)

[Akash_Varuna]

Hi Could you try this

VAR __StartDate =
CALCULATE(
MAX('ParameterTable'[ParameterValue]),
'ParameterTable'[ParameterName] = "StartDate"
)

VAR __EndDate =
CALCULATE(
MAX('ParameterTable'[ParameterValue]),
'ParameterTable'[ParameterName] = "EndDate"
)

VAR __DS0FilterTable5 =
FILTER(
KEEPFILTERS(VALUES('Date Dim'[FiscalBaseDate])),
AND(
'Date Dim'[FiscalBaseDate] >= __StartDate,
'Date Dim'[FiscalBaseDate] < __EndDate
)
)
If the post helped please give a kudos and accept this as a solution
Thanks in advance

[rmcgrath]

Hi - probably a dumb question, but where are you getting "Parameter Table" from?

[Akash_Varuna]

Sorry didnt share that as you need to create a table for that Prameter Table for start date and end date which will then dynamically filter without hardcoding it into DAX

[rmcgrath]

Ah ok...well, I tried adding your code and made a parameter table in the Excel workbook that contains the live connection data, but it just keeps telling me it cannot find the parameter table?

[Akash_Varuna · Accepted solution]

You have loaded the data to power bi model right ? and if you are on live connection like direct mode then i think it will not load but only query it so try switching to import 
another way is you could use what if parameter instead of the parameter table itslef i guess