Forum Discussion

Tony67's avatar
Tony67
New Member
2 years ago
Solved

How do I create a conditional column by comparing data from two existing columns?

I am new to Power Query and using Power Query to pull data in from an external file.  The data has multiple columns. The two columns, Date and Mine, are the ones that I want to use to create a new co...
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago

    use #date to create dates like #date(2024, 04, 01) for April 1st, 2024. Now you compare [Date] value with a result of division of 1 by 4 by 2024 (or whatever you do in your expression) - those are of different types which is not allowed in Power Query M. 

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
2 years ago

=Table.ReplaceValue(#"Removed Columns",each [Date],null,(x,y,z)=>if x="OBO" and y<#date(2024,4,1) then "OBC" else x,{"Mine"})