Custom date in power query

[RafaelAri]

Hello,

I need custome column in PQ, where I have already "Date" column.

If month is 2 (Feb.) to 11 (Nov.), result is the 1st day of previous month, same year, .

If monthe is 1 (Jan.), result is the 1st day, of month 12 (Dec.), last year.

Please help with the correct "if" query

[Joe_Barry]

Hi @RafaelAri 

You can try

Date.From(Date.StartOfMonth(Date.AddMonths([Date], -1)))

Hope this helps

Joe

[manvishah17 · Accepted solution]

Hi @RafaelAri ,
You can add a custom column and try this ,

if Date.Month([Date]) = 1 then #date(Date.Year([Date])-1, 12, 1) else #date(Date.Year([Date]), Date.Month([Date])-1, 1))

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[RafaelAri]

Tnx a lot @manvishah17