Forum Discussion
Power Query IF two columns have the same Data, write the value, else blank
Hi, I am trying to create a new column, where I have two columns
- FullDate
- End of Quarter
What I want is represent it in two ways,
- If FullDate and EndofQuarter is the same, write the date in a new column, if is different let it blank
- If FullDate and EndofQuarter is the same, write "End of Qtr" in a new column, if is different write "CommonDate"
Here is the reference
Hi Anonymous
Please use the following formula
if [FullDate] = [End of Quarter] then [FullDate] else null
Best regards
Michael
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------
1 Reply
Hi Anonymous
Please use the following formula
if [FullDate] = [End of Quarter] then [FullDate] else null
Best regards
Michael
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------