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

  • Cocrodile's avatar
    Cocrodile
    Helper I
    4 years ago

    I expect V5

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

      • Cocrodile's avatar
        Cocrodile
        Helper I
        4 years ago

        I am looking for a way to calculate all the data up to the end of the year