Forum Discussion

Baji_Komara's avatar
Baji_Komara
Frequent Visitor
3 years ago
Solved

Insurance progression triangle inversion

Dear powerbi team, I have a data as shown below after pivoting the data in excel i used to get progression triangle as shown below and i could able to get the generate the same progression tr...
Help
DimaMD's avatar
DimaMD
Solution Sage
3 years ago

Hi, Baji_Komara can you provide dummy data?

Baji_Komara's avatar
Baji_Komara
Frequent Visitor
3 years ago

hi DimaMD ,

Here is the sample/dummy data.

MONTHCust_IDApril-22 till datemay-22  till dateJune-22  till dateJuly-22  till dateAugust-22  till dateSeptember-22  till date
30-Apr-22MOT1208405130450030450030450030450004000
30-Apr-22MOT12120845145450014545001454500145450002750
30-Apr-22MOT1215549560450060450060450060450004000
30-Apr-22MOT12117989230450023045002304500230450023045004000
30-Apr-22MOT121318176045006045006045006045006045004000
31-May-22MOT12183761 45450045450045450004000
31-May-22MOT12194840 57450057450057450004000
31-May-22MOT12196512 10450010450010450003300
31-May-22MOT12284788 32950032950032950004000
31-May-22MOT12286620 65050065050065050004000
30-Jun-22MOT12305440  37450037450004000
30-Jun-22MOT12346170  50450050450040009800
30-Jun-22MOT12310739  6695006695006695000
30-Jun-22MOT12312064  1145001145001145000
30-Jun-22MOT12319534  9950099500983003300
31-Jul-22MOT12418992   40450040009800
31-Jul-22MOT12492118   45950003300
31-Jul-22MOT12532128   58400004000
31-Jul-22MOT12439877   2197572197573300
31-Jul-22MOT12446627   1223001223003300
31-Aug-22MOT12556880    04000
31-Aug-22MOT12565342    03300
31-Aug-22MOT12592283    04000
31-Aug-22MOT12616965    04000
31-Aug-22MOT12591062    1099503300
30-Sep-22MOT12660972     0
30-Sep-22MOT12661016     0
30-Sep-22MOT12667045     0
30-Sep-22MOT12671195     0
30-Sep-22MOT12672810     0