topic Re: Calculate the name column with most recent date in DAX Commands and Tips

Calculate the name column with most recent date

paulomoreira — Sat, 16 Jan 2021 11:19:22 GMT

Hi have 2 columns, how can i know the name of column and date for most recent date for the product.

Exemple: product 1 is column B with 20-07-2020

product 2 is column A with 3-2-2019

Product	A	B
1	10-07-2020	20-07-2020
2	3-2-2019	01-12-2018

Re: Calculate the name column with most recent date

Fowmy — Sat, 16 Jan 2021 11:54:31 GMT

paulomoreira

DAX doesn't support retrieving the column name or any meta data, you can do it in Power Query if you like.

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube LinkedIn

Re: Calculate the name column with most recent date

paulomoreira — Sun, 17 Jan 2021 09:31:05 GMT

How can i do with M?

Re: Calculate the name column with most recent date

Fowmy — Sun, 17 Jan 2021 11:37:14 GMT

paulomoreira

Create a blank Query, go to the Advanced Editor, clear the existing code, and paste the codes give below and follow the steps.

let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTI00DUw1zUyMDIAcowQnFidaCUjoJCxrhFQwNASyDQw1DUEcyyUYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Product = _t, A = _t, B = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"A", type date}, {"B", type date}},"en-gb"), #"Added Custom" = Table.AddColumn(#"Changed Type", "Recent Date", each List.Max({[A],[B]})), #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"Recent Date", type date}}), #"Added Custom1" = Table.AddColumn(#"Changed Type1", "Column Name", each let i = {[A],[B]} in Table.ColumnNames(#"Changed Type") { List.PositionOf(i,[Recent Date]) + 1}) in #"Added Custom1"

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube LinkedIn