Forum Discussion
Solved
Date Format for New Column not working for all rows
Hi, Can someone advise me what is wrong with this? The calculation works for some rows but not all. I tried to remove the - sign to add 1 month, then the opposite will appear with the date + 1 mo...
Realized I can get the same at Query Editor.
#"Added Custom1" = Table.AddColumn(#"Added Custom", "YYYYMM", each Date.ToText(Date.AddMonths([Bill Date],-1),"yyyyMM")),
Realized I can get the same at Query Editor.
#"Added Custom1" = Table.AddColumn(#"Added Custom", "YYYYMM", each Date.ToText(Date.AddMonths([Bill Date],-1),"yyyyMM")),