Transpose table per week

Hi Anonymous ,

What is the data source? Is it from an excel file or some other data source? Does the employee information contain fields that can be used to identify the week (such as a date field)? Will each week only load the data for the current week? Do you only want to get the latest two weeks of employee information? Could you please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

How to upload PBI in Community

In adddition, please review the following blog and check whether it can help you achieve your requirement.

Only Get the Last Few Periods of Data into Power BI using Power Query Filtering

Best Regards