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

     

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , date slicer you have an option for greater than there is a small icon on slicer to change type.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi amitchandak ,

 

I dont think that would let me on the standard filter.

 

I only want it so the end date field is greater than e.g. below 01/01/2020 (first parameter), but it wont let me reference the measure there.

 

Is this possible?

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , No, you are not allowed to have function, static you can have. 

    This Min is based on some other parameter ??