Forum Discussion
Brendy_P
4 years agoHelper I
Custom Calendar
Hi All
I am creating a custom calendar in the query Editor I want to add a column that if the week number is >=14 then minus13 else add 39. I think I have to add a custom column but I don't know how to write the formula in M lanuage if I am correct in saying. I have tried the condition column but I don't think I can perform this task using it. I should mention that I have a week number column
If you can guide me in the right direction I would appreciate it
Thanks for your time
Brendy_P , Power Query
new custom column
= if [week number] >=14 then [week number] -13 else [week number] +39
2 Replies
- amitchandakSuper User
Brendy_P , Power Query
new custom column
= if [week number] >=14 then [week number] -13 else [week number] +39
- Brendy_PHelper I
Thank you