Forum Discussion

MateoLogi's avatar
MateoLogi
Regular Visitor
1 year ago
Solved

Create a Virtual Table to Distribute the Execution of a Contract

I have a table with one row for each signed contract and four columns: The contract signing date. The quantity to be delivered. The delivery start date. The delivery end date. I’ve already cre...
Need Help
Tips and Tricks
  • danextian's avatar
    danextian
    1 year ago

    Hi MateoLogi 

    However, I’d like to create another chart that shows the monthly distribution based on the delivery months of the contracts. - Are you saying you want to distribute the contract based on its start and end delivery dates? For instance, if a contract starts on January 1 and ends on March 1, it should be reflected in each month from January through March? If so, please see the attached sample pbix.

     

MateoLogi's avatar
MateoLogi
Regular Visitor
1 year ago

I’m attaching the base data for your reference.

FechaNº ContratoProductoCosechaVendedorCompradorCantidadPrecioPrincipioFinRitmoDep/RenTransporteComisión VendedorComisión CompradorComisión Cocourtage
01/01/20242511208C1CEBADA2025NS                                 250,0021401/11/202530/06/2026MDESTINONO1  
03/02/20242511208C2CEBADA2025BS                                 250,0021401/11/202530/06/2026MDESTINONO1  
08/03/20242511208C3TRIGO2025CS                                 250,0021401/11/202530/06/2026MDESTINONO1  
10/03/20242511208C4TRIGO2025NS                                 350,0021401/11/202530/06/2026MDESTINONO1  
11/04/20242511208C5TRIGO2025HS                                 350,0021401/11/202530/06/2026MDESTINONO1  
31/05/20242511208C6TRIGO2024JV                                 300,0021401/02/202531/03/2025MORIGENSI0,96  
06/06/20242511208C7TRIGO2024TV                                 300,0021401/03/202531/05/2025OCORIGENNO1  
08/07/20242511208C8TRIGO2024PV                                 500,0021401/03/202515/06/2025OCORIGENNO1  
07/08/20242511208C9TRIGO2025CV                                 500,0021401/07/202531/12/2025EORIGENNO1  
28/09/20242511208C10TRIGO2025CV                                 500,0021401/07/202531/12/2025EORIGENNO1  
30/10/20242511208C11TRIGO2024AG                              1.000,0021416/01/202531/03/2025OCORIGENSI0,91  
20/11/20242511208C12TRIGO2024BG                              1.500,0021416/01/202531/03/2025OCORIGENSI0,91  
13/12/20242511208C13TRIGO2024BG                              1.000,0021401/02/202515/06/2025OCORIGENNO1,5