sharepoint list - date of a column is changed

[jps_HHH]

Hi all,

I have a sharepoint list with several columns that are filled over the time. 

For instance: Each line of that list is created when the batch finishes. Howerver, the column "release date" is only updated some days later. 

I would like to create a measure or something similar to present a graph with the number of batches already finished but without release date (in yy axis) over the time (is xx axys).  How can I get the date that the column "release date" was changed ?  

[jps_HHH]

I want to know that in January I had 20 batches waiting for release and in Febreuary I had 30 ... and so on 

[v-kpoloju-msft · Accepted solution]

Hi @jps_HHH,
Thank you for reaching out to the Microsoft fabric community forum. Apologies for the late reply. After reviewing the details you provided, I have identified few workarounds that may help resolve the issue. Please follow these steps:

If you already have historical data in Power BI, you can use DAX calculations to determine how many batches were waiting for release in each past month:

Create a Date Table to structure your data by month and year. Use a DAX measure to count batches where the "Release Date" is blank and ensure only batches created before or during the selected month are included. Build a visual with Month-Year on the X-axis and Pending Batches on the Y-axis.

If you specifically need to track when the "Release Date" field was modified, you should:
Enable Version History in SharePoint to track changes to the column. Use Power Automate to create a flow that logs changes when the "Release Date" column is updated. Store this in another SharePoint list with fields: Batch ID, Old Release Date, New Release Date, Change Timestamp.

Then, you can connect this log list to Power BI and create a report that tracks when batches received their release dates.

Kindly refer to the below link for more information:
Run a flow when a SharePoint column is modified - Microsoft Power Platform Blog
Power Query SharePoint list connector - Power Query | Microsoft Learn

I hope this could resolve your issue, if you need any further assistance, feel free to reach out. If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.