Filter by date and give back a quantity

[MarcDT21]

Hey there. I am new to Power BI so this might be a silly question. 

I have two tables (with the calendar table, 3). In the first one "KurseWeiterbildung" I have all visited course dates from our employees with the course details. In the second one "I have two date columns kind of "last qualification" - "next qualification". And now I would like to get to know how many visited courses are lie between this timespan.   

Thank you verry much for helping me! 

[Anonymous · Accepted solution]

Hi @MarcDT21 ,

Please check the measure.

Measure = CALCULATE(COUNT('Table'[id]),FILTER('Table','Table'[date]>=SELECTEDVALUE('Table (2)'[start date])&&'Table'[date]<=SELECTEDVALUE('Table (2)'[end date])))

Best Regards,

Jay

[MarcDT21]

late, but thank you very much - it works just fine!

[amitchandak]

@MarcDT21 , You need a common person ID dimension, Create one  and try a measure formula like

new table -Person

Existing table -KurseWeiterbildung, mitareiter. I used easy different column name for dates

countx(filter(values(Person[personNumber]), max(KurseWeiterbildung[DatumKurs]) >= min(mitareiter[StartDate]) && max(KurseWeiterbildung[DatumKurs]) <= min(mitareiter[EndDate])),KurseWeiterbildung[IDMAUrs])