Forum Discussion

BillyT_350's avatar
BillyT_350
Icon for Helper V rankHelper V
5 years ago

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...
Need Help
Show and Tell
Tips and Tricks
BillyT_350's avatar
BillyT_350
Icon for Helper V rankHelper V
5 years ago

@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.

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
5 years ago

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.