Hi everyone, im struggling with PowerBI service. The result is that the Calendar table is setting date columns as UTC. The impact is that reports I have showing revenue by month is being offset by an hour because my time zone is GMT.
To expand on the issue. I have a table of contracts. These have start and end dates, monthly revenue amounts and the contracted product. I use a function to calculate the pro rated monthly revenue. The function creates a row for every month with a pro rated factor and the month date. I use that date to plot the contract revenue on a matrix. Cols = Months, Rows = Product, Values = Measure (Revenue * Pro Rated Factor). I have a contract that starts on the 1st Oct 2020. This issue causes 1 hours revenue to be reported in Sept.
I can understand I need to handle localisation when dealing with datetime’s but in my case I only go to date level. Im assuming its a fault in the Service but wondered if anyone else has experienced this issue and has a solution?