Is there a way to limit month dimension when comparing current year with last year?

[spagad6263]

Hi,

I created a comparison chart for this financial year and same month last year. Our financial year starts from Apr. Below is the chart shows the comparison but I would like to remove the months such as Nov 2022, Dec 2022, as we are only in Oct 2023. Any suggestions?

Below is what I would like to see

[spagad6263]

I used the second one and it works beautifully. Much appreciated!

[amitchandak · Accepted solution]

@spagad6263 ,

I am hoping you are using a date table

Try

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))

or

Year behind Sales = if( Max(Date[Date]) <= today() , CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date])) , blank())