I am trying to create the report from raw data so it is a bit difficult to visualize the correct tables.
I have attached the updated sample version.
Can you please be able to guide me through the next steps to create the proper connection and get the forecast per item at the annual level to be split into weekly and monthly numbers?
Also, I tried to create a link between the Week in the Financial Year column in the Date table and the Line Number column in LedgerPeriodAllocation table but it is still many to many relationships.
NupurDemand Forecast Sample.pbix (1.6 MB)