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     ...
Need Help
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.