Get value on a record where the date falls between two dates

[Anonymous]

Hi i have a calendar table and I'd like to pull the iteration from another table into a new field or measure

Here's  a screen print of my objective

So if the date on the left is between 12/26/18 -01/08/19, I want to reference the Iteration-Original,which is 2018Q4-IP

if the date on the left is between 01/09/19 -01/29/19, I want to reference the Iteration-Original,which is 2019Q1-1

How do i write a measure or create a column to do this?

If a column, would it be better to create it as a power query column or a dax column?
I'm thinking that a new column where the iteration-Original can be added, as compared to a measure, but not sure.

Open to any suggestion.
Thanks, Steve

[jdbuchanan71 · Accepted solution]

@Anonymous 

A column like this should get you what you are looking for.

Iteration = 
VAR _Date = [Date] 
RETURN
CALCULATE(
    MAX ( Iterations[Iteration-Original] ),
    Iterations[IterationStartDate] <= _Date && Iterations[IterationEndDate] >= _Date
)

[Anonymous]

Your code made the difference. I did make a few modifications but your code acted as a template and I can use it going forward.  Thanks!