Bar chart showing all months when I only want last 3 months while using calculated measure

[Anonymous]

Hey Team,

Im trying to display blank values as 0 and tried to add that to the chart.

Total Tickets = CALCULATE(COUNTA('Data'[Ticket])+0)

When I try to use this to the bar graph it shows me all the months from 2020 and 2021 for some reason.

How would I be able to just show Dec 2020, Jan 2021 and Feb 2021 (Last 3 months) 

[Anonymous · Accepted solution]

HI @Anonymous,

I'd like to suggest you add a variable to extract and store the current date. Then you can add an 'if statement' to package your expression and compare it with the current date and block some calculations on not wanted ranges.

Total Tickets =
VAR currDate =
    MAX ( Calendar[Date] )
VAR prevDate =
    DATE ( YEAR ( currDate ), MONTH ( currDate ) - 3, DAY ( currDate ) )
RETURN
    IF (
        MAX ( 'Data'[Date] ) >= prevDate
            && MAX ( 'Data'[Date] ) <= currDate,
        CALCULATE ( COUNTA ( 'Data'[Ticket] ) + 0 )
    )

Regards,
Xiaoxin Sheng