Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I am new to Power BI and trying to generate a report for users with last login date. I am able to successfully import the data in PowerBI as per below tabular format.
Users | Login Date |
user1 | Aug 14, 2019 |
user1 | Aug 13, 2019 |
user1 | Aug 12, 2019 |
user2 | Aug 12, 2019 |
user2 | Aug 11, 2019 |
user3 | Aug 16, 2019 |
user3 | Aug 14, 2019 |
user3 | Aug 13, 2019 |
output required -
Users | Last Login Date |
user1 | Aug 14, 2019 |
user2 | Aug 12, 2019 |
user3 | Aug 16, 2019 |
Thanks in advance for any thoughts/suggestions.
Solved! Go to Solution.
Hi @powerBIuser_34 ,
Create a measure
Hi @powerBIuser_34 ,
You can achieve it by using the system default aggreation function "Latest" or creating a measure as below:
MLogin_Date = CALCULATE(MAX('Users'[Login Date]),FILTER(ALL('Users'),'Users'[Users]=MAX('Users'[Users])))
Best Regards
Rena
Hi @powerBIuser_34 ,
Create a measure
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |