• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

DAX - last occurrence in a month

yanivvl

New Member
I have [income]- (REVENUE) table of accounts, each account can have multiple instances for one month. how can I find the last occurrence of all the accounts in a month (and then summarize all of these latest occurrences)?

account revenue revenue_date
1 100 2010-01-01
1 200 2010-02-03
1 300 2010-02-04
1 1000 2010-06-04
2 100 2010-02-01
2 200 2010-03-03
2 1300 2010-07-04
2 11000 2010-08-04
3 2100 2010-01-01
3 2200 2011-02-03
3 300 2011-02-04
3 221000 2011-06-04
4 222 2010-02-01
4 2222 2012-03-03
 
Hi yanivvl, and welcome to the forum! :awesome:

A couple of questions:
1. Is your actual data sorted like in your example?
2. Are the accounts numerical, or strings? (aka, are they just numbers, or do they have letters/dashes in them?)

Also, to make sure I understand which lines you want, could you highlight the lines in your example that should be counted, so I know I'm on the same page.
 
Hi yanivvl, and welcome to the forum! :awesome:

A couple of questions:
1. Is your actual data sorted like in your example?
2. Are the accounts numerical, or strings? (aka, are they just numbers, or do they have letters/dashes in them?)

Also, to make sure I understand which lines you want, could you highlight the lines in your example that should be counted, so I know I'm on the same page.

hi luke ,
1-no , the data is not sorted , its in sql table. Does it matter?
2-numerical.
Can I sent to your email POWERPIVOT file that contains the whole data , so you can look at them closely? So send me your email address. Many thanks!
 
Back
Top