Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am looking to calculate a measure for the average number of nofications sent per hour for that realtive day.
what is the average number of notifications for tuesday at 6am for the entire data set ( 2mil rows)
then i am hoping to compare it to the current hours volume of notifications
@Anonymous ,
Could you share some sample data and clarify more details about your requirement?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
i cannot share this type of data unfourtunately
i have create measure counting ID and calculated measure for count today
i am tracking notifcations that are sent out, over time and then trying to get a granular view of notifications sent today in coparision to the past. i have made calculated columns identifying today and this hour
ISDay Of Week =
VAR Currentrowdate =
FORMAT ( 'Date'[Date], "mm/dd/yyyy" )
VAR istoday =
FORMAT ( TODAY(), "mm/dd/yyyy" )
VAR DayOfWeek =
DAY ( Currentrowdate )
VAR TodaysDay =
DAY ( istoday )
RETURN
IF ( DayOfWeek = TodaysDay, "yes", "no" )
@Anonymous ,
How about change the measure to calculate column? In addtion, could you share some sample data and post your expected results?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The answer to this depends heavily on your data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
User | Count |
---|---|
94 | |
79 | |
74 | |
63 | |
60 |
User | Count |
---|---|
110 | |
101 | |
84 | |
64 | |
62 |