calculate(meaure, date column = max(date column))

[Lenastray]

Hello everybody, please your assistance with this issue.

We have a table Table1 that has a date column and has a relationship with a date table. We have a measure Measure1 over Table1 that sums a column ColumnA like:

Measure1 := sum(Column1)

Now, if we fix Measure to give the calculation for a specific date like Calculate(Measure1, dateColumn = date(2020,11,27)) is all working perfect.

But if we do Calculate(Measure1, dateColumn = max(dateColumn)) its give error and if we use a variable like

var variable1 = max(dateColumn)
Calculate(Measure1, dateColumn = variable1) , it gives the measure for all dates, not for the max when is filtered for the date table.

We tried using filter, variables with same result. It’s some dax logic that we are overlooking?

Please, thanks to all in advance

[amitchandak · Accepted solution]

@Lenastray , Try like

Calculate(Measure1, filter( Table, Table[dateColumn] = max(Table[dateColumn])))

[Lenastray]

Thanks a lot,  I use a minimum modification that resolve the issue

[amitchandak · Accepted solution]

@Lenastray , Allexpcept or allselected need to used

Calculate([Measure1], filter( allselected(Table) , Table[dateColumn] = max(Table[dateColumn])))

or

Calculate([Measure1], filter( Table, Table[dateColumn] = max(Table[dateColumn])) , allexcept(Table, Table[COl1])

[amitchandak · Accepted solution]

@Lenastray , Try like

Calculate(Measure1, filter( Table, Table[dateColumn] = max(Table[dateColumn])))

[Lenastray]

Ty amitchandak, but it returns the measure for all dates in date column. columnDate is a column from Table1 and its filtered by the date column of the date table. The problems I see is at the context transition. max() says give me the max over the current filter conext, but when is filtered by the date table, for max the max table is the current date for all the rows of the date column of the date table.