Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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)
Solved! Go to 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
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
Hi - probably a dumb question, but where are you getting "Parameter Table" from?
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
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?
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