PowerPivot: Return Value if date in a range

Val Isted 21 Reputation points

I am using Excel PowerPivot.
I know this should be really simple to achieve but I'm struggling.
Thank you for you help in advance.

I have two tables.

Date Table:

Time Records:

All I want to do is add a column into the Time Records Table that returns the Date Table[Period] for the Time Records[Date]

Could you please assist me in the Dax required to achieve this.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,578 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,487 questions
0 comments No comments
{count} votes

Accepted answer
  1. Lz._ 8,991 Reputation points

    @Val Isted

    I might have misunderstood what you wanted to achieve in my previous reply. The following returns the DateTable[Period] where TimeRecords[Date] falls between DateTable[StartDate] and DateTable[EndDate]:

    MIN ( DateTable[Period] ),
    FILTER (
    TimeRecords[Date] >= DateTable[StartDate]
    && TimeRecords[Date] <= DateTable[EndDate]

0 additional answers

Sort by: Most helpful