Hi,
is there a formula in power query, that i can use to roll a month column 3 months ahead?
Say there is a table and there is a column that's called Renewal Month. And this column has dates shown as MM-DD-YYYY. How do i create a query step that every time i run it it does the following...
1. We are in August, so when i open it in the month of August. It filter that column so it shows everything in December.
2. Then in Sept when i open the file it filters and shows everything in January.
3. Then in Oct when i open the file it filters and shows everything in February.
4. Then in Nov when i open the file it filters and shows everything in March. and so on...
Please advise.
Cele
is there a formula in power query, that i can use to roll a month column 3 months ahead?
Say there is a table and there is a column that's called Renewal Month. And this column has dates shown as MM-DD-YYYY. How do i create a query step that every time i run it it does the following...
1. We are in August, so when i open it in the month of August. It filter that column so it shows everything in December.
2. Then in Sept when i open the file it filters and shows everything in January.
3. Then in Oct when i open the file it filters and shows everything in February.
4. Then in Nov when i open the file it filters and shows everything in March. and so on...
Please advise.
Cele