How to make my card display 2019 when i click year = 2019 ?

[admin11]

Hi All

Now i have below expression working fine , it will display April 2021.

Month Last =

FORMAT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY())),"mmm-yyyy")

May i know how to change the above expression , so that when i click on year=2018 , the card will display 2018 ?

https://www.dropbox.com/s/fy1zq137nrjb3ng/PBT_V2021_400%20GL_TI_6.pbix?dl=0

Above my PBI file

Paul

[v-yalanwu-msft · Accepted solution]

Hi @admin11  , 

You could  change YEAR(TODAY()) to the value of the slicer，Here can use MAX() ,as follows:

_Month last =
FORMAT (
    DATE ( MAX ( 'Date'[YEAR2] ), MONTH ( TODAY () ) - 1, DAY ( TODAY () ) ),
    "mmm-yyyy")

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.  

[Fowmy]

@admin11 

Try

Month Last =

FORMAT(
    DATE(
        YEAR( SELECTEDVALUE(DATE[YEAR])),
        MONTH(TODAY())-1,
        DAY(TODAY()))
    ,
    "mmm-yyyy"
)

[admin11]

@Fowmy 

i use your expression , when i select year = 2017 , but it display 1905