Dynamic Filter

[Anonymous]

Hi there,

I had a query which was resolved and functioning, whereby the 'End Date' field was no greater than the Parameter start date. 

https://community.powerbi.com/t5/Desktop/Running-Measure-filter/m-p/1255365#M553100

This however, when creating a relationship with the New End Date and Parameter end date, messed up measures I had in place. I was just wondering if somebody could help me with this problem ,where it wouldnt show a row that has an end date greater than the Param start date and not have the relationship to the parameter start date mess up other data in that table. Would it require a third date table possibly?

Thanks

[amitchandak]

@Anonymous , You can have active , inactive join. And use userelation with one date table. Also, you can use crossfilter to remove join and creat join of your choice. 

The current employee is an example in this blog where join with start date has been removed

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

You can have independent table if needed