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

There is another table (worklogs) with Developer, Logged Working hours, SprintName and a Timestamp.

 

How can I use the SprintStartDate, SprintEndDate to display only entries from the other table within this given timestamp?

Do I have to script something here?

 

many thanks for hints (sorry I am new on this)

best regards

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    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]))