Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
Solved! Go to Solution.
EVALUATE ADDCOLUMNS( SUMMARIZE( TalbeName, TalbeName[UserLogin], TalbeName[applicationname], TalbeName[applicationversion] ), "MaxConDate", CALCULATE(MAX(TalbeName[connectiondate])), "Rows", 1 )
EVALUATE ADDCOLUMNS( SUMMARIZE( TalbeName, TalbeName[UserLogin], TalbeName[applicationname], TalbeName[applicationversion] ), "MaxConDate", CALCULATE(MAX(TalbeName[connectiondate])), "Rows", 1 )
Hi,
Thanks a lot !! I learned one other thing 🙂
Regards
Sébastien
You may refer to the article below.
https://www.sqlbi.com/articles/from-sql-to-dax-grouping-data/