summurize or groupby function ?

[Hussard]

Hi,

Sorry for this question, but I tried to create a new table with Dax functions but it failed. i tried with summurize function but it doesn't work...

Could you help me to translate this SQL statement to a dax function ?

select max(connectiondate), UserLogin, applicationname, applicationversion,COUNT(*)
from LogTable
group by UserLogin, applicationname, applicationversion

Thanks a lot

Sébastien

[nickchobotar · Accepted solution]

@Hussard

EVALUATE
ADDCOLUMNS(
	SUMMARIZE(
	 TalbeName,
	 TalbeName[UserLogin],
	 TalbeName[applicationname],
	 TalbeName[applicationversion]
	 ),
"MaxConDate", CALCULATE(MAX(TalbeName[connectiondate])),
"Rows", 1
)

[Hussard]

Hi,

Thanks a lot !! I learned one other thing 🙂

Regards

Sébastien

[v-chuncz-msft]

@Hussard,

You may refer to the article below.

https://www.sqlbi.com/articles/from-sql-to-dax-grouping-data/