Forum Discussion

Rimple_Manni's avatar
Rimple_Manni
Frequent Visitor
3 years ago

Matrix issues

Hi Everyone, I'm struggling in this code, if anyone can help please - I want to fetch only last values from different months and show in a matrix. For example -

 
 
Jan - $4,724,484.1
 
Feb - $6,321,244.7

 

 

5 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi Rimple_Manni 

    try like

    1) add a column like:

    MONTH = FORMAT([Date], "mmm")

     

    2) plot a visual with the month column and a measure like:

    LastRevenue=

    VAR _monthtable =

    FILTER(

            ALL(TableName),

            MONTH([Date]) = MONTH(MAX([Date]))

    )

    VAR _lastdate =

    MAXX(

        _monthtable,

        [Date]

    )

    RETURN

    MAXX(

        FILTER(

            _monthtable, 

            TableName[Date] = _lastdate

        ),

        TableName[Online Revenue]

    )