Forum Discussion
Power Query - Newbie Question - Comparing Two Columns with Dates
Hello: Power Query newbie here. I have a Query in Power Query. There is a Column called "Start Date" and there is a column called "T-2" Date. I would like to compare these two columns. ...
if you want to copare row by row, go to add column tab pick custom column tab in the oppened window use the next formula
if [Start Date] = [T-2 Date] then "yes" else "no"but if you want to check the whole table once, use the next formula in a new step. (imagin your previous step name is Source)
Source[Start Date] = Source[T-2 Date]
if you want to copare row by row, go to add column tab pick custom column tab in the oppened window use the next formula
if [Start Date] = [T-2 Date] then "yes" else "no"but if you want to check the whole table once, use the next formula in a new step. (imagin your previous step name is Source)
Source[Start Date] = Source[T-2 Date]