Showing latest month only values in chart

[vicsinc]

Hi

I have a table that shows 2 metrics by brand by month over a 12 month period.

I want to create a chart that only shows the most recent month's 2 metrics by brand.

I am struggling with the DAX - I tried to calculate the Latest Date but it doesn't like it because I have multipe rows with the same date?

So in the example below, I only want me chart to display Feb figures.

Any help would be apprecaited. Thank you.

Victoria

Brand	Month	Category	Total
Brand1	01/01/2022	Type1	140
Brand1	01/01/2022	Type2	120
Brand2	01/01/2022	Type1	93
Brand2	01/01/2022	Type2	77
Brand1	01/02/2022	Type1	180
Brand1	01/02/2022	Type2	157
Brand2	01/02/2022	Type1	98
Brand2	01/02/2022	Type2	87

[v-zhangti · Accepted solution]

Hi, @vicsinc 

You can try the following methods.

Measure:

Measure =
IF (
    SELECTEDVALUE ( Market[Month] )
        = CALCULATE ( LASTDATE ( Market[Month] ), ALLSELECTED ( Market ) ),
    1,
    0
)

Put measure into the filter of the view and set it equal to 1.

https://docs.microsoft.com/dax/lastdate-function-dax 

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vicsinc]

To add,

I thought maybe I could do it as a summarise but it errors. This is what I tried:

Market Summarised =

SUMMARIZE (

    'Market',

    'Market'[Brand],

    'Market'[Category],

    "Counts",

        CALCULATE (

            MAX ( 'Market'[Count] ),

            FILTER ( 'Market', 'Market'[Month] = MAX ( 'Market'[Month] ) )

        )

)