Forum Discussion

itsmebvk's avatar
itsmebvk
Icon for Continued Contributor rankContinued Contributor
3 years ago

Date Column Date (UTC) to Localtime (AEST) Issue

  Hi Folks,   I am facing some date issue related to timezone.   I have a Date table (Azure analysis Service Model is source) in that table i have a Date column and other date related fields.  W...
Need Help
olgad's avatar
olgad
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Hi, 
what about adding 7 day filter in Power Query?
add column TodaysDate 
= Date.From(DateTimeZone.FixedUtcNow())
Change the data type to Date
then 

if [Date] <= [TodaysDate] then if [Date] >= Date.AddDays([TodaysDate] , -6) then 1 else 0 else 0

If today needs to be excluded then 
if [Date] <[TodaysDate] then if [Date] >= Date.AddDays([TodaysDate] , -7) then 1 else 0 else 0
And use it as a filter to filter for last 7 days.