cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
venugovi Visitor
Visitor

Measures from Desktop Different Outputs on PBI Web

Hey All,

 

I'm running into a strange problem when publishing to the online web service, where my measures will calculate fine and output on the dekstop, but once I publish to the web service and view the same published report online the measures do not compute and output blank. The DAX formulas I'm using that it seems not to like are something like:

 

Four Hour Production Rate = CALCULATE(AVERAGE('ePFS Reports'[Good Parts Production Rate (parts/hr)]), 'ePFS Reports'[Date Time] >= (NOW()-4/24))
 
Where i take any timestamps that are greater (later) than 4 hours ago, e.g. the last 4 hours. This measure works fine and outputs correctly on PBI desktop, but once I publish to the PBI Web service these measures come up blank. My other data including the raw stuff and other measures seem to come in correctly, including other measures that use the "NOW" in conjunction with the "CALCULATE", though all my measures that include "AVERAGE" seem to be failing.
1 REPLY 1
Super User
Super User

Re: Measures from Desktop Different Outputs on PBI Web

Hi there

What it could possibly be is that all the Power BI Servers have their time set to UCT.

When using NOW() it will be the time of the UTC server, so depending where you are in the world, it could mean your timezone is a day behind or ahead from the Power BI Servers, which will affect your measure.

What you could do, is to add in the Hours to your NOW() so that it offsets to the correct DateTime.

Power BI Desktop uses the Timezone on your PC, which I am going to assume is different from UTC

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 311 members 3,003 guests
Please welcome our newest community members: