Forum Discussion
Dynamic date parameters?
- 1 year ago
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 - 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
- rmcgrath1 year agoAdvocate III
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_Varuna1 year agoSuper User
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