Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 29 | |
| 27 | |
| 24 | |
| 24 | |
| 18 |
| User | Count |
|---|---|
| 54 | |
| 50 | |
| 43 | |
| 33 | |
| 32 |