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.
Hello Experts,
I am new to powerbi and would appreciate your help.
I have a sample data as below:
ID | Date |
1 | 15-09-19 |
1 | 20-10-19 |
2 | 10-08-19 |
2 | 23-11-19 |
3 | 29-11-19 |
3 | 15-12-19 |
3 | 07-01-20 |
Expectation: I want to add a column which would contain only True or False values based on the below logic
For a given ID, the row with max date should display True else False
The expected table should look like:
ID | Date | T/F |
1 | 15-09-19 | F |
1 | 20-10-19 | T |
2 | 10-08-19 | F |
2 | 23-11-19 | T |
3 | 29-11-19 | F |
3 | 15-12-19 | F |
3 | 07-01-20 | T |
Looking forward to response.
Thanks
Solved! Go to Solution.
Thanks a lot to you both @v-lionel-msft and @az38 for your help and replies.
Feel happy to be part of this community.
Keep up the good work guys!
Thank you @az38 for the quick response, but the following command is giving me an error after RETURN
Thanks @az38 for the quick response but the below command is giving me an error after RETURN
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |