blank values

[Anonymous]

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))

[HoangHugo · Accepted solution]

You said, you already have Month column, so function MONTH(Data[Month] is not true. Try this one

current_month_sales = CALCULATE(SUM(Data[NetSales]),FILTER(Data,Data[Month]=MONTH(TODAY())))

same as last_month_sales