Forum Discussion
Running Measure filter
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 🙂
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
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 🙂
Thankyou so much for explaining - that works perfectly.
One question, I have other measures running off of the Parameters, will the new relationship interfere at all?
Thanks
Hi Fowmy ,
I have a measure that goes into the table along with new start date and new end date, and by creating this relationship it has changed the results.
Is there a way around this?
Thanks
Anonymous
As per your original question and the explanation you provided, my solution works, great!
Now it is a matter of configuring and adapting it to your model.
Maybe you can raise the new question in the forum to get your new question answered.________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂