Skip to main content

Power BI

New

Ability to use dax calculations for values in query parameters

Vote (10) Share
Ankit Patira's profile image

Ankit Patira on 04 Jun 2016 06:35:55

Currently creating new parameters you can only supply static values regardless of the type of the parameters. Allow ability to use dax to set parameter values.

For example for Date type parameter I should be able to use Today () function to set parameter value.

Comments (2)
Ankit Patira's profile image Profile Picture

bf868bc5 149b-4278-a721-1930585235d9 on 05 Jul 2020 22:30:48

RE: Ability to use dax calculations for values in query parameters

I Agree with Ankit, for example you could create a URL that filters data (oData) based on the date. Would help to reduce the amount of data retrieved by the Power BI Report hugely.

Ankit Patira's profile image Profile Picture

2f301c42 7e36-428c-875e-b7d9a7d02373 on 05 Jul 2020 22:22:54

RE: Ability to use dax calculations for values in query parameters

Hello Dear Ankit
Could you provide some more context about what new parameter you create?