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?

 

Thanks

 

Liam

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

     

16 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    you could add a custom column 

     

    = Table.AddColumn(#"Renamed Columns", "Custom", each if [End Date] > [Start Date] then [End Date] else null) 

     

     

    then filter out the null values. 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous ,

       

      Apologies, it will be a parameter date so e.g. MIN(date[date]), which will be a moving date so I dont think this will work in a column form.

       

      Thanks

       

      Liam

      • Fowmy's avatar
        Fowmy
        Super User
        6 years ago

        Anonymous 

        Create Measure like MyParameterDate

        Add new column in the calendar table in the model as: Calendar[Date] < MyParameterDate

        Now place that New Column in the page filter and set to TRUE.

         

        This will dynamically filter the calendar table based on the measure value.

        ________________________

        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 ??