Reply
avatar user
Anonymous
Not applicable

Difference between service and desktop in measure

Hello, 

I've just realized of power bi service and desktop are representing different values from the same item....

For example I have created a new column to calculate working days

 

 

Laboral Day =
VAR EsFinDeSemana = Dates[Number Day] IN {7}
VAR EsFestivo =
    RELATED(TablaFestivos[Fecha])

RETURN
 
       IF (EsFestivo || EsFinDeSemana,0,1)

 

 

 

when I watch the result I have different values in desktop and service. 

In desktop 

Lburgos_0-1671009716806.png

 

In service:

Lburgos_1-1671009750572.png

Any idea ?

 

I already saw some post about utc time and GMT but I'mnot sure how to manage this....

 

 

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

Hi @Anonymous ,

 

This may be due to a discrepancy between the local time zone and the time zone corresponding to the service, please refer to:

Power BI Service Time Differences and How to Fix It (linkedin.com)

Re: Convert UTC to local time zone in DAX - 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.

View solution in original post

1 REPLY 1
v-henryk-mstf
Community Support
Community Support

Hi @Anonymous ,

 

This may be due to a discrepancy between the local time zone and the time zone corresponding to the service, please refer to:

Power BI Service Time Differences and How to Fix It (linkedin.com)

Re: Convert UTC to local time zone in DAX - 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.

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)