Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Select data according to certain date

Hi everyone,  I would ask for your support and knowledge to help me to solve this topic. I have a set of prices, for few contracts, launched in some dates. I need to filter all the items which its ...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi camargos88 ! Thanks for your answer. I think that may succeed, but the date should be the MAX in the Date column, instead of static. I know well, that October 30th is the latestet in the example, but the data model will be updated on a daily basis.

 

Cheers

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous ,

 

You can replace this block with:

 

CALCULATE(MAX(TABLE[DT_DATE]), ALL(TABLE))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi camargos88 ! Sorry for the late feedback, but I'm just today coming back to this. I've tried:

    ContratosVivos =
    VAR _date = DATE(SELECTEDVALUE(UDM_DMO_FORWARD_VALOR[Ano_Contrato]), SELECTEDVALUE(UDM_DMO_FORWARD_VALOR[UDM_DMO_TIPO_CONTRATO.FIM]), 1)
    RETURN IF(_date >= (CALCULATE(MAX(UDM_DMO_FORWARD_VALOR[DATA_COTACAO]), ALL(UDM_DMO_FORWARD_VALOR))),1,0).
     
    The outcome is still returning items with all the months from 2020, and it should be all the forward months comparing to the latest date from the query. 
     
    What do you suggest to correct this?
     
    Thanks once more!
    • camargos88's avatar
      camargos88
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Anonymous ,

       

      você pode colocar uma massa de dados aqui como exemplo ?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago
        DATA_COTACAOAno_ContratoVALORCONTRATO_TIPOMês Contrato
        22-08-20122012943Ago3
        22-08-20122012938Set3
        22-08-20122012949Q43
        22-08-20122013972Q13
        22-08-20122013988Q23
        22-08-2012201310135Q33
        22-08-20122013104Q43
        22-08-2012201410855Cal3
        22-08-2012201511345Cal3
        22-08-20122012894Ago4
        22-08-201220128895Set4
        03-11-20202021646Q44
        03-11-202020216427Q34
        03-11-202020216408Q24
        03-11-202020216343Q14
        03-11-202020216275Jan4
        03-11-202020206215Dez4
        03-11-202020206125Nov4
        03-11-202020326572Cal3
        03-11-202020316572Cal3
        03-11-202020306572Cal3
        03-11-202020296572Cal3
        03-11-202020286572Cal3
        03-11-202020276572Cal3
        03-11-202020266572Cal3
        03-11-202020256346Cal3
        03-11-20202024619Cal3
        03-11-202020236015Cal3
        03-11-202020225685Cal3
        03-11-202020215451Cal3
        03-11-202020215635Q43
        03-11-202020215515Q33
        03-11-202020215362Q23
        03-11-202020215292Q13
        03-11-202020215245Jan3
        03-11-20202020518Dez3