Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Running Measure filter

Hi,   Is it possible to filter the page to say only display when e.g. table1[End Date] is greater than the Parameter[start date]?   I was hoping this could be a running measure if thats possible?...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    Anonymous 

    Check the attached file. I created a relationship between Parameter Table and the Room Utilization Table. Added a New Column in Room utilization table to Flag more than MIN. The Report filters the new column with value TRUE.


    https://1drv.ms/u/s!AmoScH5srsIYgYImqrSWw9X3ydaXuw?e=NDL21k



    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    I accept KUDOS 🙂

    YouTube, LinkedIn

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Fowmy ,

 

I have a measure that goes into the table along with new start date and new end date, and by creating this relationship it has changed the results.

 

Is there a way around this?

 

Thanks

Fowmy's avatar
Fowmy
Super User
6 years ago

Anonymous 

As per your original question and the explanation you provided, my solution works, great!
Now it is a matter of configuring and adapting it to your model.

Maybe you can raise the new question in the forum to get your new question answered.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn