Forum Discussion

Hussard's avatar
Hussard
Frequent Visitor
7 years ago
Solved

summurize or groupby function ?

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

Need Help
  • nickchobotar's avatar
    nickchobotar
    7 years ago

    Hussard

     

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

3 Replies