Forum Discussion
Anonymous
4 years agoNot applicable
Claim triangles in PowerBI
Hello Community, I am trying to build some claim triangles in PowerBI. I won't bore you with the details as I have one specific question for the matrix visual. I have data in the following fo...
Anonymous
4 years agoNot applicable
To explain the 2nd point further. I have added the 'Reporting_date' column directly in my data. It is a sum of the 'Time_claim_occured' and 'Time_units_delay' where the delay is in quarters.
My matrix visual now looks like this:
And the measure calculation looks like:
Sum X Quarters =
VAR xQuarters = SELECTEDVALUE('Claim Development Quarters'[Claim Development])
VAR xDates = SELECTEDVALUE('Claim Occured Date'[Claim Occured Date])
VAR Result =
CALCULATE(
[Total sales],
Triangle[TIME_UNITS_DELAY] <= xQuarters,
Triangle[TIME_CLAIM_OCCURED] = xDates
)
RETURN
IF(Result = 0, 0, Result)How can I write in the measure the IF statement or something similar? It should 'calculate until' the 'reporting_date is <= to the xDates. I tried including this in the CALCULATE, but it returns weird results.