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.
Hi all,
i'm facing a strange situation with a measure, so let me explain.
Here my measure :
Default year = year(max('Calendar'[Date])) Default Month = MONTH(max('Calendar'[Date])) Sales Default 2 = CALCULATE(sum(Sales[ Sales]); FILTER('Calendar';'Calendar'[Year]= [Default year] && 'Calendar'[Month]=[Default Month]))
so the aim is to get the last value of my Month and Year, in my table my last month is 12 and year 2017, this will give me 12 385 113€.
But !! in my measure i dont have this number, i have the sum of all my data :
Can you help me please
thanks
Solved! Go to Solution.
So you're just wanting the sum of sales for the last month on your calendar table? Why not try something like:
Sales Default 2 =
var lastdateinsample = max('Calendar'[Date])
var relatedmonth = startofmonth(lastdateinsample)
return calculate(sum(Sales[ Sales]);'Calendar'[Date]>=relatedmonth)
So you're just wanting the sum of sales for the last month on your calendar table? Why not try something like:
Sales Default 2 =
var lastdateinsample = max('Calendar'[Date])
var relatedmonth = startofmonth(lastdateinsample)
return calculate(sum(Sales[ Sales]);'Calendar'[Date]>=relatedmonth)
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |