cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## DAX CALCULATED COLUMN

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

1 ACCEPTED SOLUTION
Super User

@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]))

2 REPLIES 2
Community Support

@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.

Super User

@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]))

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors