Hi all,
Bit of a rookie with power query, but trying to adjust some data as part of a report that I am running.
i want to compare 2 dates and if the date in column b is in a later month than the date in column a then enter the month name of column b, if not enter the month name of column a.
currently I am adding custom columns to extract date names and comparing against each other, but feels a bit of a long winded way of doing it!
Can anybody help me with a formula to achieve this?
Bit of a rookie with power query, but trying to adjust some data as part of a report that I am running.
i want to compare 2 dates and if the date in column b is in a later month than the date in column a then enter the month name of column b, if not enter the month name of column a.
currently I am adding custom columns to extract date names and comparing against each other, but feels a bit of a long winded way of doing it!
Can anybody help me with a formula to achieve this?