How to show data in below format?

[Sachi08]

Month	Total Billed Count	Apr-24	May-24	Jun-24	Jul-24	Aug-24	Sep-24	Oct-24	Nov-24	Dec-24	Jan-25	Total paid Count
Apr-24	13158	3179										3179
May-24	13188	2000	1932									3932
Jun-24	12366	1974	968	1000								3942
Jul-24	11635	1948	1012	422	715							4097
Aug-24	11800	2071	1057	447	286	554						4415
Sep-24	11779	2091	1145	503	321	219	432					4711
Oct-24	11579	2138	1164	554	346	238	168	386				4994
Nov-24	11599	2109	1154	532	366	217	169	139	283			4969
Dec-24	11531	2204	1231	583	325	248	206	172	102	331		5402
Jan-25	7569	742	376	163	102	59	56	48	32	27	65	1670

[v-shex-msft]

Hi @Sachi08 ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[v-shex-msft · Accepted solution]

Hi @Sachi08,

You can create a unconnected date table and use raw table date field as row, new table date as column to design a matrix visual.
After these steps, you can create new measure formula to summary records based on current date:

formula = 
VAR cRowDate =
    MAX ( 'Table'[Date] )
VAR cColumnDate =
    MAX ( NewTable[Date] )
RETURN
    IF (
        cRowDate <= cColumnDate,
        CALCULATE (
            SUM ( 'Table'[Bill] ),
            FILTER ( ALLSELECTED ( 'Table' ), [Date] <= cRowDate && [Date] <= cColumnDate )
        )
    )

Regards,

Xiaoxin Sheng

[danextian]

Hi @Sachi08 

Not very straighforward. This will involve using a disconnected  table containing the column headers. Measures would have been enough if not for that extra column before the months and the custom total column name.

[Irwan]

hello @Sachi08 

i am not sure how your data looks like but here i create a simple example to create as your visual above.

1. create a new calculated column which has exact same value as your date column.

2. create a matrix visual and grab the values in matrix

3. dont forget to tick Column Subtotal ON as you want to have a row sum value at the right side of matrix.

Hope this will help.

Thank you.