See example below.

Our group forecasts project hours and adjusts accordingly every 2 weeks. We then compare the current forecast hours with the same hours that were submitted 2 weeks prior for any variance. I'm struggling with bringing this date into PowerBI to calculate variances. I'm open to any suggestions .. calculated columns, measures, etc.

I think I'm struggling because there are a number of variables to consider, but as an example I need to know the difference in hours for Texas, Project A for the month of January that was uploaded on the 6th from the hours for Texas, Project A for the month of January that was uploaded 2 weeks prior to that.

See Data example below - Not all Data is shown, but I'm hoping this gives an idea ... Locations: I have about 15 locations Hours Last Uploaded: I will upload forecasted hours (by month) every 2 weeks for each of the projects Project: Each Location has about 20 projects.

Location Hours Last Uploaded Project    Month    Forecast Hours
Texas      1/6/2025  Project A  January    50
Texas      1/6/2025  Project A  February   50
Texas     1/6/2025   Project A  March      100
Texas     1/6/2025   Project A  April      200
Texas     1/6/2025   Project A  May    75
Texas     1/6/2025   Project A  June       50
Texas     1/6/2025   Project A  July       100
Texas     1/6/2025   Project A  August     30
Texas     1/6/2025   Project A  September   20
Texas     1/6/2025   Project A  October    20
Texas     1/6/2025   Project A  November   10
Texas     1/6/2025   Project A  December   50
Texas     1/6/2025   Project B  January    50
Texas     1/6/2025   Project B  February   75
Texas     1/6/2025   Project B  March      100
Texas     1/6/2025   Project B  April      290

I've tried it all, but I can't seem to get this to calculate and I think I'm struggling with all the variables. I think a filter function may help, but I'm not executing it properly