IF two dates in the same month, but different dates

[dgkallan]

I'm working with HR data.  I will have a Run Date, which will typically be the first of the month.  Then, I will have another date, such as Termination Date in that file which could be any date (if that person left).  I want to mark as "1" if the Termination date is in the same month as the Run Date, else a "0"

For example

Employee	Status	Termination Date	File Run Date
11111	Inactive	9/7/2023	9/1/2023

I want to create a custom column that would mark this as a "1" since file run date and termination date are in the same month.  If termination date had been 10/7/2023, that would be a "0".

[dgkallan]

wdx223_Daniel or anyone else for that matter,

I realized one flaw in my design.  I actually need to match up the File Run Date with the Termination Date for when the Termination was in the previous month.  So, in easy speak  (File Run Date) month - 1 month = Termination Date month 

[wdx223_Daniel]

=if Date.ToText(Date.AddMonths([File Run Date],-1),"yyyyMM")=Date.ToText([Termination Date],"yyyyMM") then 1 else 0

[wdx223_Daniel · Accepted solution]

=if Date.ToText([File Run Date],"yyyyMM")=Date.ToText([Termination Date],"yyyyMM") then 1 else 0