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.
Hi all,
So I am having the hardest time with converting my power bi Reports to Central time. I have changed the time zone using DateTimezone.Switch Zone, looked through all of the forums, but I still can't do it correctly. Currently, How I am doing this is I've made my date data Time and Date data, and then I convert using above M by -5 (from UTC Time). Then, I use that new column in my visual.
The code I am using to pull the data for the visual is this:
COALESCE(COUNTROWS(FILTER('Census',[Exit Date Central].[Date] = TODAY())),0)
I want to create DAX codes that will pull a total number of times something occurs within the day so for example. I want to show how many exits there were between 12a-12a on May 19th in Central Time.
I'm very new to Power BI, so if there is another way that this can be done please provide me all of your wisdom!
Thank you!
Solved! Go to Solution.
@viwinski7 ,Based on what I got from the problem
You have utctoday() and utcnow(), that you can use and add time to get your time zone
new =
var _1= utcnow() + time(5,30,0)
return
date(year(_1), Month(_1), day(_1))
@viwinski7 ,Based on what I got from the problem
You have utctoday() and utcnow(), that you can use and add time to get your time zone
new =
var _1= utcnow() + time(5,30,0)
return
date(year(_1), Month(_1), day(_1))
Thank you for your insights. However, when I do this, I'm still getting data that was captured from the previous day. So instead of 31 exits from our facility, I am still getting 36. . . because last night after 7pm there were 5 more exits. how do I make it so it's only counting the number of exits between 12a-12a in Central time?
here is my updated code:
Coalese(Countrows(Filter('Census', [Exit Date]. [Date] = DATE (Year(Var_1), MONTH (Var_1), DAY(Var_1)))),0)
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |