topic Re: Get a column value by a date range in Developer

Get a column value by a date range

SeleneLindsay — Mon, 26 Sep 2022 15:04:10 GMT

Table1

Name	StartDate	EndDate
Sprint 1	04/09/2022 14:50:47	11/09/2022 18:10:48
Sprint 2	11/09/2022 18:30:00	25/09/2022 00:00:00

Table2

Worklog	DateEntry	Time
WorkLog1	06/09/2022 14:00:00	3h
WorkLog2	11/09/2022 19:30:00	5h

I would like to create a column in table 2 that is the name of the column in table 1.

The dateEntry sets the name if it is in the range between StartDate and EndDateTable 2

Like this.

Worklog	DateEntry	Time	Name
WorkLog1	06/09/2022 14:00:00	3h	Sprint 1
WorkLog2	11/09/2022 19:30:00	5h	Sprint 2

I tried using the DAX below, but it doesn't work.

#GetNameSprint =

VAR currentValue = SELECTEDVALUE(Table2[DateEntry])

RETURN

CALCULATE(VALUES(Table1[Name]), FILTER(Table1, currentValue >= Table1 [StartDate] && currentValue <= Table1 [EndDate]))

How can I build a DAX that it works for this?

Re: Get a column value by a date range

Anonymous — Tue, 27 Sep 2022 01:51:44 GMT

Hi @SeleneLindsay ,

You can create a calculated column as below in Table2 to get it, please find the details in the attachment.

#GetNameSprint = CALCULATE ( MAX ( 'Table1'[Name] ), FILTER ( 'Table1', 'Table2'[DateEntry] >= 'Table1'[StartDate] && 'Table2'[DateEntry] <= 'Table1'[EndDate] ) )

Best Regards

Re: Get a column value by a date range

SeleneLindsay — Tue, 27 Sep 2022 18:27:30 GMT

Thanks! Thanks!