Forum Discussion
M / Power Query Dynamic 25-Calendar-Months to Date Filter
Hello, PBI community. I am working on a way to filter imported data for dynamic date ranges. This particular attempt aims to filter for only the month to date and the preceding 24 calendar-months. T...
@edhans A problem that I'm having with this now is getting the time zones to display for the user in US Central Time. Any advice? I'm also exploring it in this thread.
See if this article helps BillyT_350 . About mid-way down there is a detaled discussion on how to show things in your local time zone using the following, which would be for the central TZ:
=DateTimeZone.SwitchZone(DateTimeZone.LocalNow(),-6 + varDSTOffset,0)Please be sure to mark one or more of these responses as a solution. This thread is still showing as unresolved.