I'm newbie in here. I got a problem that really need your helps 😞
I'm building customer reports and I have a raw table like this:
Col1: User's name
Col2: User's email
Col3: User's System ID
Col4: Created Date
(I highlighted the important columns in the picture below)
Now I want to create a new table, based on above raw table.
The table I want will look like:
Col3: Accumulated Created Users
(In this case, I want this result will be:
I tried this DAX:
= SUMMARIZE('base Users','base Users'[system_id],'base Users'[Created Date 2],"Accumulated Created Table",CALCULATE(COUNT('base Users'[email]),FILTER(ALL('Date'[Date]),ISONORAFTER('Date'[Date],MAX('Date'[Date]),DESC))))
But here is the result
As you can see, the result is failed because of 2 reasons:
1. I want the date is sort DESC
2. The Accumulated Column is not correct.
Please kindly take a look and give me some advisers.
No worries. You were actually quite close already, only a minor modification was missing. Just a matter of some more practice.
On a different, note please always show your sample data in text-tabular format in addition to (or instead of) the screen captures. A screen cap doesn't allow people to readily copy the data and run a quick test and thus decreases the likelihood of your question being answered. Just use 'Copy table' in Power BI and paste it here. Or, ideally, share the pbix (which is what you did at the end and got you the solution pretty quickly :-). Beware of confidential data.