Forum Discussion

sboghani's avatar
sboghani
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago
Solved

Changing Parameter in Dataset Yields Old Value for Measurement Only

I'm able to successfully change my parameter StartDate and have it's updated value be used in my query upon refreshing. But I also want to display StartDate in the report, so I created a measure Star...
Need Help
  • nandukrishnavs's avatar
    nandukrishnavs
    6 years ago

    sboghani 

     

    Follow the below steps.

    Create a parameter.

     

    Create another query as a reference to the previously created parameter.

    Then convert to table

    Now you have the parameter value in the table.

    Create a new measure

    StartDateValue = MAX('StartDate (2)'[Column1])

     

    This should work in your scenario. Please test this.



    Did I answer your question? Mark my post as a solution!
    Appreciate with a kudos     🙂

nandukrishnavs's avatar
nandukrishnavs
Icon for Community Champion rankCommunity Champion
6 years ago

sboghani 

 

Follow the below steps.

Create a parameter.

 

Create another query as a reference to the previously created parameter.

Then convert to table

Now you have the parameter value in the table.

Create a new measure

StartDateValue = MAX('StartDate (2)'[Column1])

 

This should work in your scenario. Please test this.



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂