Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 month, but those rows that are visible in - 1 will then be blank.
What I need is to reduce the month by 1 for all Bill Date.
Solved! Go to Solution.
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")),
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |