Forum Discussion

AGonza123's avatar
AGonza123
Frequent Visitor
5 years ago
Solved

Formula to compare previous cells

ARRIVAL DATE    END DATE 2/3/2021                 9/3/2021 15/3/2021             17/3/2021   Hello! I would have a doubt which formula to use to compare previous cells, I want to perform a logica...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, AGonza123 

    Please check the below picture and the measure below, which are for creating a measure.

    The link to the sample pbix file is down below.

     

     

    https://www.dropbox.com/s/6s2vcied9g2blg4/agonza.pbix?dl=0 

     

    Result =
    VAR currentenddate =
    MAX ( 'Table'[End Date] )
    VAR enddatepreviousrow =
    CALCULATE (
    LASTNONBLANK ( 'Table'[End Date], MAX ( 'Table'[End Date] ) ),
    FILTER ( ALLSELECTED ( 'Table' ), 'Table'[End Date] < currentenddate )
    )
    RETURN
    IF (
    ISFILTERED ( 'Table' ),
    IF (
    SELECTEDVALUE ( 'Table'[Arrival Date] ) <> BLANK ()
    && SELECTEDVALUE ( 'Table'[End Date] ) <> BLANK ()
    && enddatepreviousrow <> BLANK (),
    "ok",
    "verify"
    )
    )
     
     

    Hi, My name is Jihwan Kim.


    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, AGonza123 

I am not sure whether the below is what you are looking for.

Please kindly check.

 

 

https://www.dropbox.com/s/nu1qvf4nh5sf5hv/PRUEBA%20QUIEBRES.pbix?dl=0 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

AGonza123's avatar
AGonza123
Frequent Visitor
5 years ago

Thank you very much for answering! I saw the file but what I would be needing is to compare not the quantities, but the dates of the column "quiebres" vs the column "compras" of the same row and also look at the previous cell, because what I would like is for me throw a kind of alert when there are subsequent dates! where the conditions would be the same as if my break cell is different from white and the other one for "compras" is different from white and the previous "compras" date is also different from white, "verify", if the break date cell is the same to blank, and the purchase date cell as the previous purchase date is equal to blank, "SQ", and if the break date is equal to blank and any of the other two "compras" cells are other than blank, " entry without request ", I took as an example the measure that had been suggested to me the first time and added the conditions but it did not bring me the correct results, it is found in the following link, is it possible to use that measure?

In the image you can see the dates of the "quiebre" column and the "compras" column and I want to apply the condition for each row of the "quiebre" and "compras" dates, and the previous "compras" date.

 

 

https://www.dropbox.com/sh/ikok13fofy3nyn0/AABGUF2PvBjYDt2iYbhX8m8ia?dl=0