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+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!!

 

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.

4 Replies

  • 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.