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.
Thank you for the data.
You can create a measure using the following formula.
It will be best if you create a calculated column by summing up all the columns in every row. to get total roll up amount
Total =
VAR totalvalue =
CALCULATE ( SUM ( 'Table'[RollUp] ), REMOVEFILTERS ( 'Table' ) )
VAR monthvalue =
CALCULATE ( SUM ( 'Table'[RollUp] ) )
VAR Total =
IF ( ISBLANK ( monthvalue ), BLANK (), totalvalue )
VAR CurrentDate =
MAX ( 'Table'[Month] )
VAR rollupYTD =
CALCULATE (
SUM ( 'Table'[RollUp] ),
FILTER ( ALL ( 'Table' ), 'Table'[Month] < CurrentDate )
)
VAR result = Total - rollupYTD
RETURN
result
You can get result as follows
Thanks,
Sayali
If this post helps, then please consider Accept it as the solution to help others find it more quickly.
Proud to be a Super User!
Thank you for the data.
You can create a measure using the following formula.
It will be best if you create a calculated column by summing up all the columns in every row. to get total roll up amount
Total =
VAR totalvalue =
CALCULATE ( SUM ( 'Table'[RollUp] ), REMOVEFILTERS ( 'Table' ) )
VAR monthvalue =
CALCULATE ( SUM ( 'Table'[RollUp] ) )
VAR Total =
IF ( ISBLANK ( monthvalue ), BLANK (), totalvalue )
VAR CurrentDate =
MAX ( 'Table'[Month] )
VAR rollupYTD =
CALCULATE (
SUM ( 'Table'[RollUp] ),
FILTER ( ALL ( 'Table' ), 'Table'[Month] < CurrentDate )
)
VAR result = Total - rollupYTD
RETURN
result
You can get result as follows
Thanks,
Sayali
If this post helps, then please consider Accept it as the solution to help others find it more quickly.
Proud to be a Super User!
Could you provide how the data looks like? In this example, it is not possible to know how we get the first value.
Regards,
Sayali
Proud to be a Super User!
Hi, @prakash11440278
Does @sayaliredij ’s solution can work for you?
If it is, please mark the helpful replies or add your reply as Answered to close this thread.
It will help other community members easily find the solution when they get the similar issue.
Best Regards,
Community Support Team _ Eason
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |