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...
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
)
nickchobotar's avatar
nickchobotar
Skilled Sharer
7 years ago

Hussard

 

EVALUATE
ADDCOLUMNS(
	SUMMARIZE(
	 TalbeName,
	 TalbeName[UserLogin],
	 TalbeName[applicationname],
	 TalbeName[applicationversion]
	 ),
"MaxConDate", CALCULATE(MAX(TalbeName[connectiondate])),
"Rows", 1
)
Hussard's avatar
Hussard
Frequent Visitor
7 years ago

Hi,

 

Thanks a lot !! I learned one other thing :)

 

Regards

 

Sébastien