Sending EOD numbers issue with UTC at month end

Power BI Online Service
15

Hi @nico,

It’s working as expected for me, ofsetting the current date in the date table by hours. As shown here, refresh took place April 7th but “todays date” in the date table is April 6th.

image
image829×361 31.2 KB

I’ve attached my sample, so you can give this a go as well. Determine the required number of offset hours and update the CurrentDate in inside the function query: utcCalendar

CurrentDate = Date.From( DateTimeZone.FixedUtcNow() + #duration( 0, -9, 0, 0))

eDNA - Offset Date by Hours.pbix (83.7 KB)

I hope this is helpful