i have a one table in that table there is date field and from that field i extract year and month and month name.. like month is 1,2 ,3 till 12 and month name like jan , feb, march .
so i calculate like this current month and last month sales but this shows blank
current_month_sales = CALCULATE(SUM(Data[NetSales]),FILTER(Data,MONTH(Data[Month])=MONTH(TODAY())))
last_month_sales = var current_month= MONTH(TODAY()) return CALCULATE(SUM(Data[NetSales]),FILTER(Data,MONTH(Data[Month])=current_month -1))