Forum Discussion
sidyahmed_pbix
3 years agoFrequent Visitor
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.
I finally found i way to do that, thanks
3 Replies
- amitchandakSuper User
- sidyahmed_pbixFrequent Visitor
that doesn't seem to be what i want to have- sidyahmed_pbixFrequent Visitor
I finally found i way to do that, thanks