Forum Discussion

Sachi08's avatar
Sachi08
Frequent Visitor
1 year ago
Solved

How to show data in below format?

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 13...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

Irwan's avatar
Irwan
Super User
1 year ago

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.