Forum Discussion

T_Francis's avatar
T_Francis
Frequent Visitor
4 years ago

Calculate by Last 7 days or Column Filter

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

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      T_Francis
      Frequent Visitor
      4 years ago

      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.