Calculate by Last 7 days or Column Filter

[T_Francis]

Hi, 

I'm still finding my feet with Power Query and am in need of some help please.

So I need a Total invoice amount (which I already have a measure for) filtered by all open contracts (contract status has its own column) OR any contract status, open or otherwise, that have been dated in the last 7 days (I have a date table).

The below is what I have, I hope I'm close but it's just throwing up errors.

Relationships if needed

Thanks in advance for your response, im truly stuck here.

Theo

[amitchandak]

@T_Francis , In the case or Try to add a filter on the table like

qcontracttohire[date] <=max(date[date]) && qcontracttohire[date] >=max(date[date]) -7

[T_Francis]

@amitchandak, 

Thank you for getting back to me.

So i'm trying to create a measure, is that wrong are you saying I should try to add a new column?

My data is across multiple tables.