Forum Discussion

sklement's avatar
sklement
Frequent Visitor
5 years ago
Solved

Use date fields for from/to filter

Hi all,   I have a question about displaying table entries within a given date from/to in another table. Here we go:   There is a table with (Sprints) SprintName, SprintStartDate, SprintEndDate ...
  • amitchandak's avatar
    5 years ago

    sklement , Try a measure like

    calculate(countx(filter(worklogs, worklogs[SprintName] = max(Sprints[SprintName]) && worklogs[Timestamp] >= Min(Sprints[SprintStartDate]) && worklogs[Timestamp] <= max(Sprints[SprintEndDate])),worklogs[SprintName]), values(worklogs[SprintName]))