Cumulative total of users- troubles

[Ankit_1987]

Hi, 

i know people has asked about this multiple times and I have tried them all but dont seem to be working in my case. 

This is what I got when I selected users (took Count) and date.

what I want is arrange them as they happen..November & december are from 2017 so iseal result would show November 88, December 342, January 452 & so on....

I have tried calculate = Count type methods for calculated columns and some measures too..but cant seem to be working

Please help

[Ashish_Mathur · Accepted solution]

Hi,

See if my solution here helps.

[Ashish_Mathur]

Hi,

Share the link from where i can download your file.

[Ankit_1987]

Hi Ashish,

Here is the file..

https://www.dropbox.com/s/ztdrev93ojxs1dj/file.xlsx?dl=0

[Ashish_Mathur]

Hi,

You may download my solution from here.

Hope this helps.

[Ankit_1987]

I think I will mention I did not created month_order table as yourself as I noticed it was not usd in any of the calculated column/measure

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBIX file.  I will correct for the error.

[Ankit_1987]

HI,

There you go 

https://www.dropbox.com/s/vvaia5rok6cphcn/Max_Dash_Test.pbix?dl=0

Thanks

[Ashish_Mathur · Accepted solution]

Hi,

See if my solution here helps.

[Ankit_1987]

I dont know get  the fact that why I cant replicate what you did. I guess I need more practice.

Thank you so much @Ashish_Mathur.. I was struggling with this for a week.

[Ashish_Mathur]

You are welcome.

[Ankit_1987]

@Ashish_Mathur

Hi Ashish, 

So the solution you provided for the problem in the subject line works for the cumulative table for the user count.

But it is not working for a different table in the same report.

Now I have another table record and want to do the same thing with it.

I applied the same formulas there, Do i need to make another calender table using a date column of record table, like you did above.

So if you notice above at lefthand side total new users & cumulative users tiles are matching..i.e. 87+ 254 is 341 and so on...

but on the righthand side..above tile starts from .3k and below one starts from .6k. What i have done is applied the same formulae

that you used for cumulative user count to another table that has record column in it.

I also made a relation between new table and calender table. but it still not giving me what I want..

Here is the pbix file..

[Ashish_Mathur · Accepted solution]

Hi,

You may download my solution from here.

Hope this helps.

[Ankit_1987]

Hi @Ashish_Mathur

Thanks for the revert..your pbx file is working fine.

But when I applied (simply copy pasted formulas for new measures and table ) into my existing pbix file it is giving me this..