DAX CALCULATED COLUMN

[Anonymous]

Hello,

I´m trying to create a new column to calculate de tons (Tm) of the last month.

Cannot be a measure!!!

For example, I have the next table: 

And I need add the column to have the next table

[V-pazhen-msft]

@Anonymous 

For the sample table you provided, you can get the expected column with the following dax:

Column = CALCULATE(MAX([TM]),FILTER('Table','Table'[Name]=EARLIER('Table'[Name]) && 'Table'[Month]=EARLIER('Table'[Month])-1))

However, it is recommended to transform it to a date column: date = date(left([month],4), right([month],2),1) OR separate Year and Month into 2 columns: Year = left([month],4) and Month = right([month],2)

In this way it is easier to deal with data for a few years.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@jmfreire , Have date column or month range

date (left(left([month],4), right([month],2),1)

a continuación, intente 1 de los dos
last month ? sumx(filter(Table, [name] ?earlier([name]) && eomonth([date],0) ? eomonth(earlier([name]),-1)),[TM])
last month ? sumx(filter(Table, [name] ?earlier([name]) && eomonth([date],0) ? eomonth(earlier([name]),-1)),earlier([TM]))