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
OwenAuger's avatar
OwenAuger
Super User
8 years ago

Hi robarivas

 

Could you explain a bit more how you want the filtering to work in this measure, with an example?

 

Since there is a many-to-many relationship between TransactionsTable and TableA (hopefully I've got that right), you could have a multiple values of TransactionsTable[Post Date] 'related to' multiple values of TableA[Particular_Date_Field]. 

 

Say for example the rows with Transactions[Post Date] = 1 Jan...10 Jan are related to rows with TableA[Particular_Date_Field] = 5 Jan..15 Jan

Which rows would be included for the purposes of the measure?

 

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.