Forum Discussion

Cocrodile's avatar
Cocrodile
Helper I
4 years ago

Data forecast

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The formulas I used :

----------------------------------------------
A-B = sum(TABLE[A])-sum(TABLE[B])
------------------
V1 = calculate ([C] ,filter (TABLE,TABLE[key]=14) )
---------------------------------------------
V2=stocks = calculate ([V1] , ALL(TABLE)
---------------------------------------------
V3= if ([C]=BLANK() && [V2]<>BLANK() ,[V2]+[A-B],[C])
---------------------------
V4 = if( sum(TABLE[key])=15,[V3])
------------
V5 = if ([C]=BLANK() ,[V4],[C])
----------------------------------

I should calculate all the expected values up to month 7 as in column V5 but I only made one step.

The 54 in is the result in V5 = 77 -23.

77 is the last C value -23 is A-B.

I need a formula that takes all the written formulas and does this calculation for me dynamically.

Thank you it is very urgent

 

 

Need Help

4 Replies

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    Hi, Cocrodile 

     

    What do you expect the output to look like? Can you show it in a picture?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • v-zhangti's avatar
        v-zhangti
        Community Support
        4 years ago

        Hi, Cocrodile 

         

        You can try the following methods.

        Measure = 
Var _AB=SUM('Table'[A])-SUM('Table'[B])
Var V2=CALCULATE(SUM('Table'[C]),FILTER(ALL('Table'),[Key]=14))
Var V3=IF(SELECTEDVALUE('Table'[C])=BLANK()&&V2<>BLANK(),V2+_AB,SUM('Table'[C]))
Var V4=IF(SUM('Table'[Key])=15,V3)
Var V5=IF(SELECTEDVALUE('Table'[C])=BLANK(),V4,SUM('Table'[C]))
return
V5

        Is this the result you expect? A formula to calculate V5.

         

        Best Regards,

        Community Support Team _Charlotte

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.