- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
In service:
Any idea ?
I already saw some post about utc time and GMT but I'mnot sure how to manage this....
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
02-29-2024 03:39 AM | |||
07-25-2024 06:20 AM | |||
Anonymous
| 03-14-2024 01:09 PM | ||
04-14-2024 04:35 PM | |||
07-02-2024 07:42 AM |
User | Count |
---|---|
48 | |
32 | |
31 | |
27 | |
23 |
User | Count |
---|---|
40 | |
33 | |
19 | |
18 | |
16 |