Forum Discussion

MarcDT21's avatar
MarcDT21
Frequent Visitor
5 years ago
Solved

Filter by date and give back a quantity

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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
MarcDT21
Frequent Visitor
5 years ago

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