Forum Discussion
Creating a Measure for Missing Scheduled Time
Good day, I am VERY new to measures and could use some guidance please. I have a table consisting of scheduled events by employees in the future. (I have a date table that maps week numbers to ea...
Anonymous , based on what I got. You can get remaining hour and use that with scheduled hour in stacked visual
Remaining Hour =Sumx(Summmarize(Table, Table[Week], Table[Employee], "_1", Sum(Table[Scheduled Hour])), 8- [_1])
Amit,
First, THANK YOU! Just a couple of follow-up questions please:
- The _1 - is that literally just that, or is that shorthand for something? What function does that serve please?
- If the fields are in the same table (ie the second screen shot above you can see "Member_ID" (which is there first intial and last name concantenated) and "Hours_Sched" is in the same table. (With multiple events being scheduled in that table obviously). The Week # is just pulled from a Date Table that has a relationship from the Date_Time_Start to the Date (of the Dates table. All that table is is just a list of dates with the week and qtr #).
- Like I said, I'm new to DAX and so (ONLY if you have a spare moment) if you could kinda summarize the logic of what's happening you'd have NO idea how much that would help me
Amit - thank you SO much for your quick and thoughtful response!
-Rob