Forum Discussion
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...
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
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