Forum Discussion

shanipowerbi's avatar
shanipowerbi
Helper III
5 years ago
Solved

Need Point in Time Last Invoice Amount

Hi Experts   I need your urgent help, I have two tables 1 - Active Users (Servers) 2 - Invoice Data Active Users (Servers) Date User ID Feb-20 126389 Feb-20 126611 Mar-20 126389...
Need Help
  • vpanchu's avatar
    vpanchu
    5 years ago

    Step 1---Create a bridge table with unique user id

     

     

    Step 2 --Create a calculated colum in the Active user table 

    Pending Invoice last month =
         LOOKUPVALUE('Invoice data'[Invoice Amount],
             'Invoice data'[Date],DATEADD('Active User'[Date],-1,MONTH)
    )
     
     
    Step3----pull the highlighted fields in a table
     
     

     

     
     

     Note: it is not showing  the Feb value for user 126389 because there is no data in the active user table , you can work on the source , but hope you got the context.

     

    Rergards

    Vpanchu