how can i get previous row

[saikiran]

Hi all,

Hope all are doing good.

 I am getting one problem can you please help me anyone as soon as possible. It's very urgent.

Studying Students end othe month = (Studying studnets+App+visa)-Graduations participated

I want output same as above table.

In my raw table i am getting counts for Studying students and App+visa counts and also Garduations participated counts.

As per my requirement after calculating the Studying students as of end of month count for july 2649 and the same count i want to carry forward to aug 2020 and after that these 2649 count should be added to aug-2020 (approved + visa count)-antipaticipated graduations and after that i will get one result. For these result i want to get into Sep-2020 and so on.

If any body knows output can you please ping me as soon as possible.

Thanks in advance!!

[amitchandak]

@saikiran , You need to measure like Cumm with the date and date calendar

Studying Students end othe month =SUM(Table[Studying studnets])+SUM(Table[App+visa])+SUM(Table[Graduations participated])

Cumm = CALCULATE([ Studying Students end othe month]),filter(date,date[date] <=maxx(date,date[date])))
Cumm = CALCULATE([ Studying Students end othe month]),filter(date,date[date] <=max(Table[Date])))

In case you do have date

Date = "01-"& [Month] and mark it as date

First 5 min video shown same -https://youtu.be/yPQ9UV37LOU

[saikiran]

Hi amitchandak,

     Thanks for r your quick response. In the studying students as of end of month i am getting 2649 (i.e.,Jul-2020) as per my calculation and the same resulet i want to carry forwrad to Aug-2020 and these value again calculated to (App+visa) - No. of anticipated Graduations then i will get another result for Aug-2020 these result i want to carry forward to Sep-2020 and so on till dec-2020. can you please try this way and once see the below tables you will get clear clarity.

Expected ouput:

Getting ouput:

Thanks in advance!!

[v-juanli-msft · Accepted solution]

Hi @saikiran 

Create measures

Measure+ = SUMX(FILTER(ALLSELECTED('Table'),'Table'[month]<=MAX('Table'[month])),CALCULATE(SUM('Table'[app+visa])+SUM('Table'[studying students])))

Measure- = SUMX(FILTER(ALLSELECTED('Table'),'Table'[month]<=MAX('Table'[month])),CALCULATE(SUM('Table'[graduations])))

Measure final = [Measure+]-[Measure-]

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@saikiran - Seems like you want EARLIER, See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...