Adding Current Measure with Previous Measure In Power BI

[Anonymous]

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

[Manishaparmar19]

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]

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]

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.