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 again OwenAuger

 

I've created a tiny .pbix example that should help demonstrate what I was looking to do. In it I created a measure. I'm trying to fix/improve that measure to match the desired results as shown in the image I inserted into the .pbix.

 

Is there a way for me to share that .pbix with you? (preferably email)

  • OwenAuger's avatar
    OwenAuger
    Super User
    8 years ago

    robarivas

    Sure, I'll PM you the email address to send the pbix :)