Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Adding Current Measure with Previous Measure In Power BI

 

Hi all

I am newbie to power Bi

 

Sales is a Calculated Measure.

 

My Requirement

 

Month             Sales            Required out put

Jan-23             200               200

Feb-23            300               200+300

March             400               200+300+400

 

Please let me know what could be dax for this. I have tried my way but was not successfull please guide

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello Anonymous, 

     

     

    Try this,

    Sales 1 = CALCULATE(
      SUM([Sales]),
      FILTER(
        ALL(Table_Name),
        Month <= MAX(Month)
      )
    )
     
    If this helps, mark my post as "Accepted Solution".
    Thanks 
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

       

      I did try the code provid the code provide by you ,Let me expain this way

       

      We have a measure called **bleep** Inflows which calculates the Cumulative Inflow based on this formula


      **bleep** Inflows (Crs) =
      SUM('Fund Flow'[Subscription Money])/SELECTEDVALUE(DimAmountConversion[RangeValue],10000000).

      I have attached a scree shot where u will have clear understanding of my requirement

      We are a requirement of another measure with name **bleep** MOM

       

      depends on date selection it will calculate

      as per below scree shot

      Jan-22=71.04

      Feb 22=38.26+71.04

      mar 22=8.75+38.26+71.04

      date selected betweeb 3/31/22 and 5/31/22

      please refer screen shot below

      we have table called Date which contains column called Date

      • v-jingzhang's avatar
        v-jingzhang
        Community Support
        3 years ago

        Hi Anonymous 

         

        Please try this measure. Hope it works!

        **bleep** MOM =
SUMX (
    FILTER ( ALLSELECTED ( 'Date'[Date] ), 'Date'[Date] <= MAX ( 'Date'[Date] ) ),
    [**bleep** Inflows (Crs)]
)

         

        Best Regards,
        Community Support Team _ Jing
        If this post helps, please Accept it as Solution to help other members find it.