Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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