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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Fowmy ,

     

    Ive created the column Filter = dimdate[date] < [ParameterStartDate] and every cell is FALSE.

     

    The calendar goes up to 2028. Would this work with a column?

     

    Thanks

    • Fowmy's avatar
      Fowmy
      Super User
      6 years ago

      Anonymous 

      Your [ParameterStartDate]  should be a measure and should not draw dates from the calendar as it will create a circular reference. Ii should be independent.

      Please share what you have done as a sample file.

      ________________________

      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 ,

         

        Ive attached the file below. In the sample I would like values to be present only if the 'New End Date' is greater than the 'ParameterStartDate' measure.

         

        I hope that makese sense. 

         

        https://1drv.ms/u/s!AtcnGX-0tS5riVQegrm-rP9nx5dX?e=Ru8O5g

         

        Thanks in advance

         

        Liam