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

     

Fowmy's avatar
Fowmy
Super User
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

Fowmy 

 

Thankyou so much for explaining - that works perfectly.

 

One question, I have other measures running off of the Parameters, will the new relationship interfere at all?

 

Thanks