Forum Discussion
Matrix
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
