Creating report with one column changes

[Anonymous]

Hello there, I'm trying to create a report for an attendance, the data is coming from a SharePoint list and it looks like this:

Name	Status	Date
Employee1	Attended	7/1/2022
Employee2	Attended	7/1/2022
Employee2	Attended	7/1/2022

The date and status will change every day.

What I want to achieve is to create a report that shows me Status let's say 7/1/2022.

I want to save that data and then I want the report to show me, Status for 7/2/2022 without deleting the date/status from 7/1/2022

I don't know if that is possible or do I need to add several rows to achieve this, I hope you can help me with this.

Ideally I want my report to look like this: 

Name	7/1/2022	7/2/2022	7/3/2022	7/4/2022
Employee1	Attended	Attended	Attended	Justified
Employee2	Attended	Attended	Attended	Justified
Employee2	Attended	Attended	Attended	Justified

[PaulDBrown]

Not possible in Power BI. Data snapshots storing values at a specific moment in time is not possible. One option you have is to create daily files from Sharepoint with a datestamp using Power Automate for example, and then upload these files into PowerBI (using pulling data from a folder as a source). The whole process can be automagic.