admin管理员组

文章数量:1403443

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

本文标签：

版权声明：本文标题：dax - PowerBI: Need to find the Variance in hours based on current data and when data was last added - many variables - Stack Ov 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1744339133a2601371.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。