Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Power BI - Salesforce Timestamp Issue

Hello,   In Power Bi Desktop I am getting data from Salesforce Objects (Case Table). Whenever the data is imported the timestamps on the dates are 5hrs ahead of time, which is throwing off our metr...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi Anonymous ,

 

How did this date field come from? From DAX formula or M function?
You don't need to create a new column, you can subtract 5 hours from this date field to get your local time.

 

__now = NOW() -TIME(4,0,0)

 

 

 

 

 

Best regards,
Lionel Chen

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