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 

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hey Liam, 

         

        See attached. I've added a simple date diff column 

        Datediff = DATEDIFF(RoomUtilisation[New End Date],[ParameterStartDate],DAY)
        then filtered out anything greater than 0 

         

        https://1drv.ms/u/s!AnIEh6WhI4JogrAAnyDVVkj51F1Xdg?e=902oee

         

        It's important to note because your ParameterStartDate is 2012 and your new End date only goes back to 2016, it's not actually filtered anything out. but it would do if you were to change the ParameterStartDate to something after 2016