Matrix

[NaviKher]

Hi Guys,

I have below data

YYYYMM	PYYYYMM	Group_Name	Group_Number	paid
202007	202007	ABC	1	248
202007	202008	ABC	1	823
202007	202009	ABC	1	365
202007	202010	ABC	1	319
202007	202011	ABC	1	594
202007	202012	ABC	1	826
202008	202008	ABC	1	333
202008	202009	ABC	1	907
202008	202010	ABC	1	428
202008	202011	ABC	1	500
202008	202012	ABC	1	203
202009	202009	ABC	1	255
202009	202010	ABC	1	692
202009	202011	ABC	1	404
202009	202012	ABC	1	993
202010	202010	ABC	1	906
202010	202011	ABC	1	230
202010	202012	ABC	1	935

I have created matrix with the help of DAX  % paid running total in PYYYYMM 

Below are the result 

Now I looking for below result 

1st Month = 7.81,14.04,10.88 etc. (First month for PYYYYMM and YYYYMM)

2nd Month = 33.73,52.30,40.40 etc. (Second month for PYYYYMM and first month for YYYYMM,third month for PYYYYMM and second month for YYYYMM etc.)

3rd Month = 45.23,70.35,57.64  (Third month for PYYYYMM and first month for YYYYMM,Forth month for PYYYYMM and second month for YYYYMM etc.)

Aspected result in Power Bi

1st Month	7.81%	14.04%	10.88%	43.75%
2nd Month	33.73%	52.30%	40.40%	54.85%
3rd Month	45.23%	70.35%	57.64%
4th Month	55.28%	91.44%
5th Month	73.98%

How do i get above data in Power bi

[Dhairya]

Hey @NaviKher, Can you please share the measure that you have plotted?

[NaviKher]

Hi Dhairya,

Here is the measure:-

paid running total in PYYYYMM =

CALCULATE(

    SUM('Sheet1'[paid]),

    FILTER(

        ALLSELECTED('Sheet1'[PYYYYMM]),

        ISONORAFTER('Sheet1'[PYYYYMM], MAX('Sheet1'[PYYYYMM]), DESC)

    )

)