Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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))
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |