Forum Discussion

saikiran's avatar
saikiran
Icon for Helper I rankHelper I
6 years ago
Solved

how can i get previous row

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+Ap...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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's avatar
saikiran
Icon for Helper I rankHelper I
6 years ago

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's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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.