Forum Discussion
Solved
How could I transform the table based on date and specific column at the same time with DAX?
Hi, All, I have a dataframe as follow. There are 2 players' training records. For calculating and present the current completion status, I have to filter the current table based on the Status and L...
Hi Steven_Wu,
You could try creating a new table in Table Tools via this code:
In plain text:
Table = SUMMARIZE ( data, [Player], [Activity Name], "Completion Date", MAX ( data[Completion Date] ), "Status", IF ( "Completed" IN VALUES ( data[Status] ), "Completed", "Incompleted" ) )Best Regards,
Alexander
Thank you, Alexander,
it's what I need. Thank you so much~