Help table facts and calendar

Good afternoon friends, I have a problem that I have already tried to solve with all the information I have found here but I do not achieve desired result. Let me explain the case. The managers of the company are asking me for a report where they can see the final inventory for each item and each item segmentation (By item segmentation I mean groups of items, e.g.: We sell household items and they fall into the household classification. Agricultural items are also sold and there is the agricultural group.). From It they pass me a MySql table with all the information outputs and inputs of products, so far everything perfect the problem arises is that in the table it is only registered when the product has movements. Let me explain myself better:
I have the article ca10 that belongs to the household group:

If you notice this product has no movements on 14-18-19, this represents a problem since as well as that we have products that can go months without any type of movement. If I take the report at the end of the month with a filter by group of inv the products that did not have movement that month do not come out so the report is not reliable.
It should be noted that I have a calendar table and facts, these related by the date of the trasanction.
I also have other dimensions:
Customers: with all the information of the clients, linked by customer code to the field of customer code of my table of facts.
Inventory: All details of inv products, including inv groups.

Try with the two solutions that I found here in the forum but with none of them worked, I leave the link.

https://community.powerbi.com/t5/Translated-Spanish-Desktop/URGENTE-Agregar-filas-con-fechas-faltantes-en-Power-Query/m-p/2574137#M427556
Thank you in advance if you can help me.