Forum Discussion
Creating report with one column changes
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 |
1 Reply
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.
