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 🙂
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.
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
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 🙂
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
Anonymous , can you give an example with data.
