Notifications
Clear all
Power Query
4
Posts
2
Users
0
Reactions
52
Views
Topic starter
Hi
Please see sample report attached.
Say I am in the year 2018, how do i filter this report so it only shows 2018, automatically? Without me having to go in and filter manually?
Please advise.
Thank you in advance,
Cele
Posted : 22/09/2017 11:18 am
Hi Cele,
See session 7.01 of the Power Query course on using Parameter Tables. Another option is shown in session 7.06 but this requires opening Power Query to change the filter.
Let me know if you get stuck.
Mynda
Posted : 22/09/2017 9:16 pm
Topic starter
I watched video session 7.01, as per your request.
Result - YOU ARE SIMPLY THE BEST!!!!!!!!!
That's exactly what I needed!!!
YOU TOTALLY ROCK!!!!!!!
Thank you Mynda!!
Regards,
Cele
Posted : 23/09/2017 12:35 pm
🙂 you're welcome!
Posted : 23/09/2017 5:33 pm
