Filter on Latest Month and display Month and Year

[nsaray]

Hi

I have 3  visuals on a page, 2 has trend informaton  so the date filters range over a few months. The last visual I only want to display data from the latest month of the available dataset.

1. How can I filter the one visual to only show the latest month's worth of data. ie. If it's currently Oct 2021, but in my dataset the last month of data  I have is May 2021, I want it to display May 2021 data.

2. How do I then also display it as Mon YYYY on a card visual (ie. May 2021)

Thanks!

[amitchandak · Accepted solution]

@nsaray , You need use the first column in date table and select last month in slicer

Month Type = Switch( True(),
eomonth([Date],0)= eomonth(maxx((Table), Table[Date]),0), "Last Month" ,
Format([Date],"MMM-YYYY")
)

You can use this measure to displat last month

last month = format(maxx(allselected(Table), Table[Date]), "MMMM-YYYY")

[nsaray]

Perfect, thank you!!