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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Apologies if I haven't explained very well.

     

    In the image below, as the Parameter start date, which has a measure containing MIN(Parameter[date]) is 14/09/2020, I wouldnt want to have anything in the table next to it with a New End date before the 14/09/2020, and as you can see theres quite a few.

     

    The date slicer still just contains the date field, but I didnt know whether I could filter off of the first date in the slicer.

     

    Maybe I would have to split the date parameters into two.