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 triangle in powerbi

But i want to generate a progression triangle in powerbi as shown below.

in excel we used select the blank spaces and shift the cell's to left to get the progression triangle as shown above but i couldn't able to geerate the same in powerbi.

Requesting powerbi team to help me out with this.

 

Thanks in advance !

4 Replies

    • Baji_Komara's avatar
      Baji_Komara
      Frequent Visitor

      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