Duplicate value

[Adaonwa]

I have the issue of my reforecast values being the same across the staff costs . question regarding the forecast values £22k in the picture below. It seems that the forecast values are repeating across the columns, and I'm not sure what might be causing this issue. Any ideas or suggestions for resolving this would be greatly appreciated.

[ManuelBolz]

Hello @Adaonwa 

If my post helped you, please give me a 👍kudos and mark this post with Accept as Solution.

I suspect your column/measure [Forecast Value] and [Actuals] are in different tables/queries. And these are not related in the data model. For example, via a date table.

Best regards from Germany
Manuel Bolz

🟦Follow me on LinkedIn
🟨How to Get Your Question Answered Quickly
🟩Fabric Community Conference
🟪My Solutions on Github

[ManuelBolz]

Hello @Adaonwa

could you please provide the community with the following:

• a few sample data (5-10 Rows)
• or a screenshot of your data
• or the Power Query M code

This means we can help you in a more targeted manner and you can integrate our solution into your existing system more quickly.

Best regards from Germany
Manuel Bolz

🟦Follow me on LinkedIn
🟨How to Get Your Question Answered Quickly
🟩Fabric Community Conference
🟪My Solutions on Github