Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    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

    Power BI User 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

    Sharon Laivand 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?