Power BI Desktop - Comparing Information Between Two Rows

[sgraber12]

Hi,
 
I am looking to compare information across two different rows in my dataset. As of now, individual files come into my dataset with "FilePeriod" dates. I want to see if the "Action Date" column changes between different file periods and then show this in a table with other data. The data is structured like this (simplified):

How would I create / calculate Column 3?

[v-zhenbw-msft]

Hi @sgraber12 ,

Sorry for that we cannot see your screenshot, could you please post another screenshot or share some sample data?

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@sgraber12 , try a new column like

 New column  
 var _1 = maxx(filter(Table,[File Period]<earlier([File Period])),[Action Date])
 return
 if(isblank(_1) , "NO", if([Action Date]<>_1,"YES","NO"))