topic Re: How to achieve the function of arg_max() from Kusto in DAX Commands and Tips

How to achieve the function of arg_max() from Kusto

siwfy — Wed, 24 Jan 2024 14:44:34 GMT

Hi all, I am new to Power BI and I need some help with DAX here. I have an existing table like this:

I need to create a new table based on column [CreatedDate], extracting the latest records for each Site. From the example above, the latest record for Site A is from 1/1/2024 and Site B from 11/1/2023, giving us the new table as follows:

In Kusto, we can achieve this easily with arg_max() operator. I wonder anyone can help me compose the DAX query here. It would be much appreciated.

Re: How to achieve the function of arg_max() from Kusto

Jihwan_Kim — Wed, 24 Jan 2024 17:52:33 GMT

Hi,

Please check the below picture and the attached pbix file.

expected result table = CALCULATETABLE ( Data, TREATAS ( GROUPBY ( Data, Data[Site], "@maxdate", MAXX ( CURRENTGROUP (), Data[CreatedDate] ) ), Data[Site], Data[CreatedDate] ) )

Re: How to achieve the function of arg_max() from Kusto

siwfy — Thu, 25 Jan 2024 01:18:41 GMT

Jihwan_Kim Thank you, you are a lifesaver.