Calculated Issue

[nkasdali]

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

[jthomson · Accepted 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)

[nkasdali]

This is it !! using variables 🙂

Thanks @jthomson, it works well nos 🙂