Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
I expect V5
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.
I am looking for a way to calculate all the data up to the end of the year
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |