Can you share some sample data with the desired output to have a clear understanding of your question? Mention whether you want a calculated column or measure. You can either paste your data in the reply box or save it in OneDrive, Google Drive, or any other cloud-sharing platform and share the link here.
Did I answer your question? Mark my post as a solution! and hit thumbs up