From the course: Power BI Data Methods (2019)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Utilizing parameters

Utilizing parameters

From the course: Power BI Data Methods (2019)

Start my 1-month free trial

Utilizing parameters

“

- [Instructor] We can define parameter as the query object that returns a single self-contained value, that minimizes reliance on outside files and we can potentially use in multiple other queries. In a new Power BI file, we're in the Power Query Editor. Where we now select Manage Parameters at the top and select New Parameter. Name this parameter Current Date and choose it's date as the Data Type. From the drop-down list of Suggested Values, we see three options. We keep it this as Any value and enter the date for the current date into the box for Current Value. I'm going to revert this back to Any, so that we can go ahead and enter the current date. We then select OK. We see loading the parameter creates a new query denoted for the parameter icon. We can change the parameter values by entering a new value into the field on the screen. Click on the Advanced Editor window, where we can see the parameter has it's own…

Contents