Solved: Query related to StartDate automatically changed t...

PoojaPrajapati · ‎11-15-2022

Hi Forums,

I have create a Entitlement Report and are used StartDate & EndDate in this report .

The StartDate and EndDate are working fine on Power BI Desktop

For Example-

But when I publising report on Power BI Service then after sometime the StartDate automatically changed to one day earlier.

For Example-

Please give me solution for this query.

Thanks & Regards

Pooja

Anonymous · ‎11-15-2022

Hi @PoojaPrajapati,

Because Power BI is using GMT (or UTC, not sure) you get the difference in time zones for TODAY or NOW functions.

You can solve it with DAX in your data model or with M in Power Query.

Reza Rad did a good job explaining it here:

https://radacad.com/solving-dax-time-zone-issue-in-power-bi

You may also refer to ：Solved: Date in Power BI Pro report is one day earlier com... - Microsoft Power BI Community

Best Regards,
Community Support Team _ Caitlyn

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

View solution in original post

PoojaPrajapati · ‎11-28-2022

Thank you all for the inputs.

But somehow my reports didn't worked with Switchzone or localzone function. Using these functions i was getting correct output on desktop but on service it was showing dates one day prior. I dont understand why.

But i resolved the issue by using duration funtion i.e. duration(0,0,0,19800) where 19800 is the conversion 5.50 hours to sec. & adding that to datetime field.