Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a report which has 2 measures:
TODAYNUMBER = DAY(TODAY())
DayPercentage = DIVIDE('Date'[TODAYNUMBER],COUNTROWS('Date'))
When I look at the pbix file, the values are correct, however when viewing the same report, with freshly refreshed data on the web, they are showing 1 less day on the TODAYNUMBER and wrong DayPercentage value as TODAYNUMBER is wrong.
I am in Australia with timezone of +10. I am going to assume that this is the problem (???) but was wondering how to fix it.
Solved! Go to Solution.
@kevinsray
The Power BI service is in UTC time always. (Yes very annoying when using time, especially when your +10.
You could change your variable by adding 10 hours.
@kevinsray
If you are using a lookup it this there has to be an exact match (so a time will not work) but you could covert the date to a date without time first.
So
DayNo =
Var currentdate = DATEVALUE(NOW()+TIME(10,0,0,0))
RETURN
LOOKUPVALUE('Date'[DayNoOfYear],'Date'[Date],currentdate)
Should work, but I don't have any date to check it on.
Best regards,
Jeroen
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
@kevinsray
The Power BI service is in UTC time always. (Yes very annoying when using time, especially when your +10.
You could change your variable by adding 10 hours.
Any idea how I could do this for day of year also?
I have the following, but it is also out 10 hours.
@kevinsray
If you are using a lookup it this there has to be an exact match (so a time will not work) but you could covert the date to a date without time first.
So
DayNo =
Var currentdate = DATEVALUE(NOW()+TIME(10,0,0,0))
RETURN
LOOKUPVALUE('Date'[DayNoOfYear],'Date'[Date],currentdate)
Should work, but I don't have any date to check it on.
Best regards,
Jeroen
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Jeroen,
You are da man. Thank you very much.
There was one too many 0`s in the time thing, but after removing, it worked perfectly.
Thank you so very much.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |