Forum Discussion

sidyahmed_pbix's avatar
sidyahmed_pbix
Frequent Visitor
3 years ago
Solved

dynamically filter a table between two dates

I have a table to which I want to return the staff who will go on leave dynamically between two dates chosen at random.
I want to create a measure that returns 1 if for the dates between the two chosen dates and 0 if not.
the first date is the date chosen at the level of the filter and the last date we add x months to the first date

my table name is Congé.
first__date = MAXX(VALUES('Congé'[date debut]),'Congé'[date debut])
lasst_date = 
EDATE([DateSelected],x)

How can i create the last mesure to return 1 or 0.

thanks.