Forum Discussion

robarivas's avatar
robarivas
Post Patron
8 years ago

Measure using EARLIER??

Not sure if using the EARLIER function is the way to go. Even if it is, I still can't figure out how to use it properly. I am trying to sum up the transactions in one table whose transaction date is ...
Need Help
robarivas's avatar
robarivas
Post Patron
8 years ago

Hello OwenAuger. Thanks for the reply. I ended up restructuring my data model to circumvent this need. But I am still curious. If Table A had rows with dates 1/1, 1/3, and 1/9 that are related to rows on the Transaction table with dates of 1/1 : $20, 1/2 : $30, 1/3 : $15, 1/4 : $25, 1/7 : $50, 1/8 : $35, and 1/11 : $80

 

then I want to be able to create the following view:

 

Table ASum of Transactions
1-Jan$20
3-Jan$65
9-Jan$175

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi robarivas,

 

On the Transactions Table, can the Date column have duplicate entries?

  • robarivas's avatar
    robarivas
    Post Patron
    8 years ago

    Hello Ashish_Mathur. No the Transactions table won't have true duplicates. Some rows may seem like duplicates in many cases because the field values are identical but that's just because the transactions table is not grouped at all. So even when one row looks the same as another row it actually really is a totally diferent transaction.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Hi,

       

      Assuming there will never be any duplicates date entries in Table1, try this

       

      1. Build a relatioship from the Date column in Table2 to the Date column in Table1
      2. In the visual, drag the Date from the Date column from Table1
      3. Write the following measure

       

      =SUM(Table2[Amount])

       

      Hope this helps.