Calculate Active Products but filter on cancellation date between slider

[gussie]

Hi Guys, 

I semi new to dax, but have experience in SQL. This is a bit of a brainbuster for me. 

So I have a date slider that is cancellation date, and I want to filter 'Active' and 'Cancelled' products. However, I want to only show active products that are created before or on the MAX(cancellation_date) and that have a cancellation date of today  and are created on or after the MIN(Cancellation Date)

Something like this:

active products = active_product.product_created_date < filter.max_cancellation_date and COALESCE(active_product.cancellation_date,GETDATE()) > filter.min_cancellation_date

Your help would be greatly appreciated

[amitchandak]

@gussie , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Refer if this blog can offer a bit of help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...