Forum Discussion

PatrickGreen's avatar
PatrickGreen
Advocate I
1 year ago
Solved

Default DAX Parameter Values

Hi! Are there options currently to set default values for DAX parameters? 

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

  • PatrickGreen's avatar
    PatrickGreen
    Advocate I
    1 year ago

    Hi lbendlin ! I have a parameter in DAX of this formula:

    date_aggregation_parameter = {
        ("Day", NAMEOF(DateTable[Date]), 0),
        ("Week", NAMEOF(DateTable[Week]), 1),
        ("Month", NAMEOF(DateTable[Month Year]), 2),
        ("Quarter", NAMEOF(DateTable[Quarter Year]), 3),
        ("Year", NAMEOF(DateTable[Year]), 4)
    }

    I added it in the sheet as a slicer, where people can select the kind of "date aggregation" they want. I want to set monthly as default when a button is clicked. I am planning to do the same as well for another parameter containing text fields. Do you think this is possible?