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 ...
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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        camargos88 Na realidade só deverão aparecer os items que Mês_Contrato > mês da data de cotação, e ano_contrato => que ano da data cotação.