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 ?

if [Day] < 16 then 
Date.StartOfMonth([Date])
else 

?????

Thanks a lot
Orhan