Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

blank values

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))
 
General Comment
Need Help
Tips and Tricks
  • HoangHugo's avatar
    HoangHugo
    3 years ago

    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

1 Reply

  • HoangHugo's avatar
    HoangHugo
    Solution Specialist
    3 years ago

    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