Displaying same period last month from timestamp column not connected to the date table
I have a model contaning energy measurements on a 15-minute timestamp level, date dimension and time dimension. What I am want to do is displaying the values in this fashion: The page is sliced by month from the date dimension, but the timestamp values on the x-axis here is from the fact table. The problem is that I also want to show last months values on top of this month values. But when I use formulas such as parallelperiod(), dateinperiod(), or dateadd() to get last months values, timestamp values will show for that parallelperiod. Any tricks to manage this? Link to .pbix: https://www.dropbox.com/s/ewh6a027fiuou75/Model.pbix?dl=0 Thanks!
No enough memory to complete this operation when loadin measure into matrix
Hi Everyone, im working on power bi report where i need to multiply "Losses 3 Years Rate" measure values based on Index Year in matrix below is the formula of "Losses 3 Years Rate": Losses 3 Years Rate = IFERROR(DIVIDE( CALCULATE ( [Incurred Claims], FILTER ( ALL( LineReport[Index Year],LineReport[UW Year]), LineReport[Index Year] <= MAX ( LineReport[Index Year]) && LineReport[UW Year] >= MAX(LineReport[UW Year])-2 && LineReport[UW Year] <= MAX(LineReport[UW Year]) ) ) , if( SELECTEDVALUE(LineReport[Index Year])=1, CALCULATE( [Incurred Claims], FILTER ( ALL( LineReport[Index Year],LineReport[UW Year]), LineReport[Index Year] <= MAX ( LineReport[Index Year]) && LineReport[UW Year] >= MAX(LineReport[UW Year])-2 && LineReport[UW Year] <= MAX(LineReport[UW Year]) ) ), CALCULATE ( [Incurred Claims], FILTER ( ALL( LineReport[Index Year],LineReport[UW Year]), LineReport[Index Year] <= MAX ( LineReport[Index Year])-1 && LineReport[UW Year] >= MAX(LineReport[UW Year])-2 && LineReport[UW Year] <= MAX(LineReport[UW Year]) ) ) ),0) it is properly generated as per the below screen shot: now i need to calculate Developement Factor which is the "Losses 3 years Rate" for index year multiply by the others for example: Dev Fac for index 1 = Rate1 * rate2*rate3*rate4*rate5*rate6*rate7*rate8 Dev Fac for index 2 = rate2*rate3*rate4*rate5*rate6*rate7*rate8 Dev Fac for index 3 = rate3*rate4*rate5*rate6*rate7*rate8 Dev Fac for index 4 = rate4*rate5*rate6*rate7*rate8 Dev Fac for index 5 = rate5*rate6*rate7*rate8 Dev Fac for index 6 = rate6*rate7*rate8 Dev Fac for index 7 = rate7*rate8 Dev Fac for index 8 = rate8 Im using the below formula: Cape Cod IL 3 Years Rate = var indexyear = SELECTEDVALUE(LineReport[Index Year]) return EXP( SUMX( FILTER(ALL(LineReport), LineReport[Index Year]<=MAX(LineReport[Index Year]) && LineReport[Index Year]>= indexyear) , LN([Losses 3 Years Rate]) ) ) however the matrix is keep loading and throw a memrory error: below is the formula i used in Matrix Value: Rate Calculation = VAR Val = SWITCH(SELECTEDVALUE('Chain Ladder'[Group]), "Premium 3 Years",[Premium 3 Years Rate], "Premium 5 Years",[Premium 5 Years Rate], "Premium 7 Years",[Premium 7 Years Rate], "Premium All Years",[Premium All Years Rate], "Premium Average",[Premium Average Years Rate], "Losses 3 Years", [Losses 3 Years Rate], "Losses 5 Years",[Losses 5 Years Rate], "Losses 7 Years",[Losses 7 Years Rate], "Losses All Years",[Losses All Years Rate], "Losses Average",[Losses Average Years Rate], "Development Factor",'Cape Cod'[Cape Cod IL 3 Years Rate] ) RETURN FORMAT(Val, "0.00000") appreciate your assistance since i cant go any further with this. Best regards, Georges
