Register
Log In
Unanswered
Home
Power Query
Excel Analysis Toolpak
Power BI
November 19, 2015
Offline
Hi,
Is there any way I can create a step on a query, that can filter a month column 3 months out? Without me having to go and fix the step, every time i open the report?
I want it to do the following. Say i want to run a report in Sept, so it filters everything in the month of December. Then in Oct it filters everything for January. In Nov it filters everything for Feb. etc.
How can I create a query step that does that, without me having to fix the step every month? Please advise?
Thanks in advance
Regards,
Cele
July 16, 2010
Offline
Hi Cele,
You can use a query parameter to set the date you want to use. See lesson 7.01 of the Power Query course.
Mynda
Power Query
Excel Analysis Toolpak
Power BI
November 19, 2015
Offline
The Power Query course i purchased only goes to lesson 6.12
Even the syllabus states that....not sure which course you are referring to...?
Â
| Â | M Language | 0:56:14 | Â | Â | Â | |
| 6.01 | Introduction to M | 0:02:24 |
|
pq_6.01.pptx | pq_6.01.pptx | |
| 6.02 | Where to Edit and Write M | 0:02:59 | Â | pq_6.02.xlsx | N/A | |
| 6.03 | Using a Function to add a Custom Column | 0:07:58 | Â | pq_6.03.xlsx | pq_6.03_c.xlsx | |
| 6.04 | Reading M | 0:05:52 | Â | pq_6.04.xlsx | N/A | |
| 6.05 | Writing M in the Formula bar & Advanced Editor | 0:03:34 | Â | pq_6.05.xlsx | pq_6.05_c.xlsx | |
| 6.06 | Type System | 0:02:45 | Â | pq_6.06.xlsx | N/A | |
| 6.07 | Lists and Records | 0:08:33 | Â | blank workbook | pq_6.07_c.xlsx | |
| 6.08 | Splitting Text | 0:06:19 | Â | pq_6.08.xlsx | pq_6.08_c.xlsx | |
| 6.09 | Tips for Writing M (Notepad++ & #shared) | 0:05:43 | Â | pq_6.09.docx | N/A | |
| 6.10 | Commenting Code | 0:01:52 | Â | N/A | N/A | |
| 6.11 | Error Trapping | 0:04:12 | Â | pq_6.11.xlsx | pq_6.11_c.xlsx | |
| 6.12 | if and Nested if Function | 0:04:03 | Â | pq_6.12.xlsx | pq_6.12_c.xlsx |
July 16, 2010
Offline
Hi Cele,
I added some new tutorials to the course (session 7) but, you must not have renewed your membership.
If you want to share your file here and explain what fields you're wanting to filter etc. then I can set it up for you, or you can renew your membership for 50% off if you prefer.
Mynda
Most Users Ever Online: 57
Currently Online:
9 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Md. Rahman
Lilian Vo
Jane Kumwenda
David Miller
Efe Onwochei
LynAnn Williams
Brandy Kriger
purna chandar
E K
velissa barr
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
