power query date format

Hello Everyone,

I have a power query issue.

I am trying to convert my date column with below condition,

IF day > 16, it will be 16/month/year

Else it will be 1/month/year

Examples : 12/May/2018 >> 1/May/2018
18/May/2018 >> 16/May/2018
30/May/2018 >> 16/May/2018
5/May/2018 >> 1/May/2018

I managed first part, but I need your help on second part.

Any Idea ?

Please Login or Register  to view this content.

Thanks a lot
Orhan

Thank you very much! It worked perfectly !

Originally Posted by CK76

Try using #date().

Ex:

Please Login or Register  to view this content.

You are welcome and thanks for the rep