topic Re: Insurance progression triangle inversion in DAX Commands and Tips

Insurance progression triangle inversion

Baji_Komara — Tue, 03 Jan 2023 06:11:50 GMT

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 !

Re: Insurance progression triangle inversion

DimaMD — Tue, 03 Jan 2023 07:23:21 GMT

Hi, Baji_Komara can you provide dummy data?

Re: Insurance progression triangle inversion

Baji_Komara — Tue, 03 Jan 2023 07:51:33 GMT

hi DimaMD ,

Here is the sample/dummy data.

MONTH	Cust_ID	April-22 till date	may-22 till date	June-22 till date	July-22 till date	August-22 till date	September-22 till date
30-Apr-22	MOT12084051	304500	304500	304500	304500	0	4000
30-Apr-22	MOT12120845	1454500	1454500	1454500	1454500	0	2750
30-Apr-22	MOT12155495	604500	604500	604500	604500	0	4000
30-Apr-22	MOT12117989	2304500	2304500	2304500	2304500	2304500	4000
30-Apr-22	MOT12131817	604500	604500	604500	604500	604500	4000
31-May-22	MOT12183761		454500	454500	454500	0	4000
31-May-22	MOT12194840		574500	574500	574500	0	4000
31-May-22	MOT12196512		104500	104500	104500	0	3300
31-May-22	MOT12284788		329500	329500	329500	0	4000
31-May-22	MOT12286620		650500	650500	650500	0	4000
30-Jun-22	MOT12305440			374500	374500	0	4000
30-Jun-22	MOT12346170			504500	504500	4000	9800
30-Jun-22	MOT12310739			669500	669500	669500	0
30-Jun-22	MOT12312064			114500	114500	114500	0
30-Jun-22	MOT12319534			99500	99500	98300	3300
31-Jul-22	MOT12418992				404500	4000	9800
31-Jul-22	MOT12492118				459500	0	3300
31-Jul-22	MOT12532128				584000	0	4000
31-Jul-22	MOT12439877				219757	219757	3300
31-Jul-22	MOT12446627				122300	122300	3300
31-Aug-22	MOT12556880					0	4000
31-Aug-22	MOT12565342					0	3300
31-Aug-22	MOT12592283					0	4000
31-Aug-22	MOT12616965					0	4000
31-Aug-22	MOT12591062					109950	3300
30-Sep-22	MOT12660972						0
30-Sep-22	MOT12661016						0
30-Sep-22	MOT12667045						0
30-Sep-22	MOT12671195						0
30-Sep-22	MOT12672810						0

Re: Insurance progression triangle inversion

DimaMD — Tue, 03 Jan 2023 10:00:18 GMT

Baji_Komara review the attached file and tell me if this is your desired result

Re: Insurance progression triangle inversion

Baji_Komara — Tue, 03 Jan 2023 10:49:27 GMT

Thanks DimaMD