Forum Discussion
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 ...
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.
Hi,
Assuming there will never be any duplicates date entries in Table1, try this
- Build a relatioship from the Date column in Table2 to the Date column in Table1
- In the visual, drag the Date from the Date column from Table1
- Write the following measure
=SUM(Table2[Amount])
Hope this helps.