Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |