Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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.
Solved! Go to Solution.
that doesn't seem to be what i want to have
I finally found i way to do that, thanks
| User | Count |
|---|---|
| 47 | |
| 35 | |
| 28 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 60 | |
| 59 | |
| 42 | |
| 22 | |
| 20 |