Change null to "local time now" but then -7 for pacific time

[Anonymous]

Hi,

I replaced the null "End Date" with local time now, but it shows up in UTC when it is refreshed in the Power Bi Service. Can I get this formula if it is null show UTC time now -7, some how?

Thanks!

= Table.ReplaceValue(#"Renamed Columns1",null,DateTime.LocalNow(),Replacer.ReplaceValue,{"End Date"})

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

In Query Editor, try like below formula:

Table.ReplaceValue(#“Replace Value”,null,DateTime.LocalNow(),Replacer.ReplaceValue,{“Time”})

If you are in powerbi desktop you can try the following formula.

ReplaceDate =
IF ( Table[Date] = BLANK (), TODAY (), Table[Date] )

Also, you can refer to similiar solution.

Solved: Convert Date/Time in UTC to Local Time with Daylig... - Microsoft Power BI Community

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[indkitty]

Hi,

Does your local time have DST? If not, you could subtract. If yes, I would create a table with DST adjustment with time offset.

Refer to this article, how to solve timezone.

Convert UTC datetime to local time zones in Power Query – Curbal