Forum Discussion
DAX time intelligence question
- Hi there
All the Power BI Servers have their dates set to UTC.
In my blog post below I detail why this is and how to make the required changes to your dataset
https://www.fourmoo.com/2017/10/03/power-bi-did-you-know-all-power-bi-services-servers-are-in-utc-now-how-to-handle-it-for-dates-times/
After I reviewed all answers in this post, I don't think I was very clear with my questions.
My ideally solution was creating an EST timezone calendar table using DAX.
This is a common date table I used in my report:
''' DAX
Calendar =
ADDCOLUMNS (
CALENDAR (DATE(2020,01,01)),DATE(2020,12,31)),
"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"MDY",FORMAT([Date],"MM/DD/YYYY/dddd"),
"YMD",FORMAT([Date],"YYYY/MM/DD"),
"Year", YEAR ( [Date] ),
"Monthnumber", FORMAT ( [Date], "MM" ),
"ISO Week",WEEKNUM([Date],1),
"YearMonthnumber", FORMAT ( [Date], "DDmmm" ),
"DayMonthShort", FORMAT ( [Date], "YYYY/mmm" ),
"MonthNameShort", FORMAT ( [Date], "mmm" ),
"MonthNameLong", FORMAT ( [Date], "mmmm" ),
"DayOfWeekNumber", WEEKDAY ( [Date] , 2),
"DayOfWeek", FORMAT ( [Date], "dddd" ),
"DayOfWeekShort", FORMAT ( [Date], "ddd" ),
"Quarter", "Q" & FORMAT ( [Date], "Q" ),
"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" )
)
```
Most answers in this post are solving this problem in the power query stage which lead me to the right direction. I have followed GilbertQ BLOG to solved my question, but I would thank you all for the answers provided.
Regards,
- Thanks for the update and details!