Getting data of only current year in a column

[Anonymous]

I have sales data for two years-last and current year.The current year data is only till march. I have made two different measures for the 2 years. Now when i show the trend of sales for current year month on month, the sales data shows for months beyond march too. That means the system picks the data for months beyond march i.e for last year. Please help.

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may try to add filters to the measure or just add a slicer.

• FILTER Function
• CALCULATE Function