The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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/
User | Count |
---|---|
74 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |