Forum Discussion

SEAM_98's avatar
SEAM_98
Frequent Visitor
2 years ago
Solved

Problem getting data from one table to another table in the range between dates

  I have problems to create a column as inputs coming from different tables. It does not pull data from the other tables. I would like to know if you have any way to solve this problem. Here is som...
  • Fowmy's avatar
    Fowmy
    2 years ago

    SEAM_98 

    I modifed the code with a different approach:

    MES_CUOTA = 
VAR _data = 'FACT COTIZACIONES'[FECHA DE CONFIRMACION DE RECEPCION DE LA OC DEL CLIENTE]
VAR _result = 
MAXX(
    FILTER(
        'DIM MES',        
        _data >= 'DIM MES'[Fecha Inicio] &&
        _data <= 'DIM MES'[Fecha Fin] 
    ),
    'DIM MES'[MES_CUOTA]
)
RETURN  _result
SEAM_98's avatar
SEAM_98
Frequent Visitor
2 years ago

Hi Fowmy 

 

I have to give you my PBI file in order to find the problem. 
https://we.tl/t-4N5jk5tkEG 

I am attaching link to download. Only have  7 days.

 

Please I look forward to your promt reply.

 

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
2 years ago

SEAM_98 

I modifed the code with a different approach:

MES_CUOTA = 
VAR _data = 'FACT COTIZACIONES'[FECHA DE CONFIRMACION DE RECEPCION DE LA OC DEL CLIENTE]
VAR _result = 
MAXX(
    FILTER(
        'DIM MES',        
        _data >= 'DIM MES'[Fecha Inicio] &&
        _data <= 'DIM MES'[Fecha Fin] 
    ),
    'DIM MES'[MES_CUOTA]
)
RETURN  _result