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

Anonymous's avatar
Anonymous
Not applicable
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