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 (contr...
Need Help
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.