Summing up revenue to selected date and display for individual months as per the selection

[Anonymous]

Hi,

I have a requirement where in I need to display total revenue as on the selected date and them show it for indiuidual months in the selected intervals, I have tried creating an YTD measure but it doesn't meet my requirement,

I am attaching the screen clip for the reference.

As it can be seen in the slicer the selected dates are 06-01-2019 to 30-11-2019, so my requirement is at the starting of the date(i.e) 06-01-2019 i want to see total revenue of previous time and then it should be individual revenue for each months.

I am struggling to figure out a way to resolve this, I would be thankful if i can get any help.

[parry2k]

@Anonymous try this for running total

Running Total = 
CALCULATE ( 
SUM ( Table[Amount] ),
FILTER ( ALLSELECTED ( Calendar ), Calendar[Date] <= MAX ( Calendar[Date] ) )
)

[Anonymous]

Thanks @parry2k 

I have got the running totals, but still i can't figure it out how to display the total revenue since strating of time at the selected start date, running total is giving me the total of staring month and then it move forward adding up revenues for each month.

Thanks.

[parry2k]

@Anonymous the measure should start from the first date selected in the slicer? Is that not working? If not can you share pbix file with sample data?

[Anonymous]

@parry2k  Here is the link to the sample .pbix file, Please do let me know if this can be achieved.

https://drive.google.com/open?id=1WYht_KjAsy1s9OJOpEn6djXrhNdL4r3l 

Thanks

[parry2k · Accepted solution]

@Anonymous try this measure , for this kind of calculations it is suggested to have calendar table in your model.

Running Total = 
CALCULATE ( 
SUM ( 'Table1'[Revenue (Base)] ),
FILTER ( ALLSELECTED ( Table1 ), Table1[Effective Start Date] <= MAX ( Table1[Effective Start Date]) )
)