Please share sample data of your table and post expected result here.
Regards, Lydia
Community Support Team _ Lydia Zhang If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Announcements
Power BI September 2023 Update
Take a look at the September 2023 Power BI update to learn more.