Difference between service and desktop in measure

[Anonymous]

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 

In service:

Any idea ?

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

[v-henryk-mstf · Accepted solution]

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.