Monthly Totals Not Working - DAX and Data Modeling

[JaclynPugh2022]

Hi,

I am trying to get monthly forecast totals to show in my power bi desktop report, however, the same overall report quantity keeps repeating for every month.  Can you help me please?   Also, I have a relationship between my calendar date table that has future dates, with the future orders table, and I'm not sure they are communicating properly, as I had to create a secondary date table to show my future dates (below) from the future orders table.  

[v-yetao1-msft]

Hi @JaclynPugh2022 

Can you provide your pbix file(remove sensitive info) to us ? From the screenshot you provided , I have no way of determining the cause of the problem . 

Best Regards,
Community Support Team _ Ailsa Tao

[JaclynPugh2022]

It appears to be that I have to create a helper table of unique part numbers to connect a relationship between historical orders and future orders tables; otherwise it is a multi relationship to multi relationship issue.  However, after updating to September 2022 Power BI Desktop to modify a query is extremely painful and slow even to do a simiple remove duplicates inside the query editor is taking hours, when it shouldn't.

[v-yetao1-msft]

Hi @JaclynPugh2022 

Desktop seems to have been updated in September, you can download Desktop again and test your problem .

Best Regards,
Community Support Team _ Ailsa Tao

[JaclynPugh2022]

Hi,  I downloaded the September 2022 version and it changed my program to RS Report server.  I'm not sure if that was the intended Power BI Desktop update for Sept 2022?

Thank you