Statement for current YEAR and MONTH

[Julia_Mav]

Hello,
I'm using this DAX:
CurrentMonthSales = CALCULATE(SUM('SALES'[Europe]),PARALLELPERIOD('SALES'[Date],0,MONTH))
How can I modify the DAX statement to have data for the current month and YEAR (2023)?

Thanks in advance!

[Julia_Mav]

Thank you @amitchandak !

[amitchandak · Accepted solution]

@Julia_Mav , Create a measure like

This year Today =
var _min = eomonth(today(),-1*month(today()))+1
var _max = eomonth(_min,12 ,-1*month(today()) )
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

refer: https://medium.com/chandakamit/cheat-sheet-power-bi-time-intelligence-formulas-using-today-654f26e27...