Hola, he creado una lógica para uno de los clientes "A" con la siguiente fórmula y está funcionando bien. PickUpCost-Cost - Costo de Var á IF(Envíos[BilledOn]< FECHA(2019,04,01), (1-0.228), IF(Envíos[BilledOn]> FECHA(2019,04,01) Shipments[BilledOn]< DATE(2020,04,01), (1-0.221), (0.219))) Return IF( LOOKUPVALUE('Financials'[Income],'Financials'[Invoice],Shipments[Invoice])-LOOKUPVALUE('Financials'[Cost],'Financials'[Invoice],Shipments[Invoice]) = LOOKUPVALUE('Financials'[Profit],'Financials'[Invoice],Shipments[Invoice]), IF(OR(LOOKUPVALUE('Financials'[ss],'Financials'[Invoice],Shipments[Invoice])<=0.2, LOOKUPVALUE('Financials'[ss],'Financials'[Invoice],Shipments[Invoice])>=0.3), Cost*LOOKUPVALUE('Financials'[PC- Income],'Financials'[Invoice],Shipments[Invoice]), LOOKUPVALUE('Financials'[PC- cost], 'Financials'[Invoice],Shipments[Invoice])), Cost*LOOKUPVALUE('Financials'[PC- Income],'Financials'[Invoice],Shipments[Invoice])) Now I am trying to create same formula for multiple customers with different Margins but it is not working Index Start Date End Date A B C D 1 1/1/2018 3/31/2019 0.228 0.209 0.228 0.228 2 4/1/2019 3/31/2020 0.221 0.209 0.221 0.221 3 4/1/2020 3/31/2021 0.219 0.209 0.219 0.219 Could anyone please help how to create formula for all customers , es muy urgente y muy importante. He intentado usar (CALCULATE (FIRSTNONBLANK('Financials'[Income],1),FILTER(ALL('Financials'), 'Scope'[Invoice] - 'Envíos'[Factura])) en lugar de la función LOOKUP pero todavía no está funcionando Por favor, hágamelo saber si se requiere cualquier otro detalle Gracias de antemano.
