Forum Discussion
Formula to compare previous cells
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 ))RETURNIF (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
Hello @Jihwan_Kim excuse me, a matter of minutes ago, I had made a query on how to compare previous cells, with the measure that you shared, it turned out great but now I have a problem, I wanted to attach more dates and in this case put additional conditions: if (arrival date [3/15/2021] <> blank () && end date [3/9/2021] <> blank (), "verify", if(arrival date [3/15/2021] <> blank () && end date [3/17/2021] <> blank () && date I finish [3/9/2021] <> blank (), "verificar", "ok") but I think that the measure no longer Register it, I would be very grateful if you could help me one last time
Super UserHi, AGonza123
Thank you for your message.
Sorry that I quite do not understand your last question.
I don't understand your last measure and I think it is saying a different thing than what you asked before.
Please write like below for your new table.
Or, please let me know how your desired outcome looks like.
-
Hello, thank you very much for your answer, I tried to explain myself better, at the beginning I thought that just showing that example of dates would work but as I have more data it gets complicated, if in power bi with that example of two dates I could already join the columns of my table a with columns of table b creating a new table but I don't know if it is the right thing to do, in the attached link you can find part of the tables and the result of how I hope it can be done, each store has its sku with dates of arrival and finish and what I want to achieve is that by having more than 10 stores united, the formula can perform this logical operation for each point, that is, it only analyzes the relationship of dates corresponding to that point and then the next point analyzes their corresponding dates I hope you understand me
https://drive.google.com/file/d/1cmjEBt4E9Yw97PwLg-Id681B-6qdYvKh/view?usp=sharing
- Jihwan_Kim
Hi, AGonza123
Thank you for your message.
I cannot access your shared file. It asked to enter the password.
Please kindly check.
Excuse me, and now could you confirm if I let you enter, both links are the same
- Jihwan_Kim
Hi, AGonza123
Thank you for your message.
Terribly sorry to say that I don't know which part I am missing.
Perhaps I did not check your previous message or comment.
Sorry but please clarify the below.
- The initial equation was, if three cells are not blank, then "OK". But do you want to change it to If three cells are not blank, then "Verify"? Am I correct?
-what is store arrival? -> in which table can I find this column?
-what is store resultable? -> in which table can I find this column?
-what is sku arrival? -> in which table can I find this column?
I had not seen your answer, excuse me because I did not express myself correctly, in the file indicate the terms as I mentioned them and with the modified formula indicating the cells, as I had previously commented I have two tables (arrival table and end table) and what I did was join them in power bi to what would be the "resultable" side table (I thought the most convenient) and on that table I would be needing to apply the formula, I hope I have expressed myself better this time, thank you very much!