how-to
3 Topics
Status of most recent task
I have a table of appointments that fall into 2 categories- Confirmed or Unconfirmed. For each Unconfirmed, there is a reason. I need to return the reason based on only the most recent unconfirmed appointment. I can calculate when the most recent unconfirmed appointment was, but I can't figure out how to return the reason. Data Appointment Date Status Reason 5/1/24 Confirmed 6/1/24 Unconfirmed Cancelled 7/1/24 Unconfirmed No Show My formula for most recent unconfirmed date would be: Most Recent = CALCULATE(MAX('Table'[Appointment Date]), 'Table'[Status]="Unconfirmed", 'Table'[Appointment Date]<=TODAY() Using the data sample above, I would get 7/1/24 as my result. Now, how do I get "No Show"? Thank you in advance for any helpSolved829Views0likes3CommentsUnmatching dates between payroll dates
Our company has 2 payroll cycles, A & B, that alternate weeks. Different pay groups are assigned to either A or B. Occasionally, a correction payroll gets run that falls out of cycle with A or B dates. Is there a way to assign these out of cycle dates to the correct payroll date depending on cycle? Example: Payroll Group A pays on 6/7/24 and 6/21/24 A correction payroll for Group A is run on 6/12/24. Because this date is after 6/7/24, but before 6/21/24, I would want any values in this correction payroll assigned to the payroll cycle immediately prior. Payroll Dates Pay Date Cycle 6/7/2024 A 6/14/2024 B 6/21/2024 A 6/28/2024 B Sample Location Information Location Pay Date Amount Cycle One 6/7/24 $100 A Two 6/7/24 $250 A Three 6/14/24 $200 B Four 6/14/24 $250 B One 6/12/24 $50 A Based on the above example, I am looking for output like this Payroll Date Location Total One 6/7/24 $150 Two 6/7/24 $250 Three 6/14/24 $200 Four 6/14/24 $250Solved691Views0likes2CommentsCount Rows on another table based on attributes on main table
I have 2 tables, one is a list of employees with employment status and the other is a list of tasks assigned to those employees with the task status. Everthing is linked by EE_ID, but I did have to create a table of just unique values to avoid Many:Many between the 2 source tables, so my relationship looks like this: Task Table *->1 Unique EE_ID 1<-* EE Status I need create a measure that tells me the list of Incomplete tasks when an Employee is Terminated so those tasks can be reassigned. I would like to present the results in a table or matrix. Desired Ouput: EE_ID Name Status Task Count 1111 John Smith Terminated 2 2222 Bob Jones Terminated 0 EE_Status: EE_ID Name Status 1111 John Smith Terminated 2222 Bob Jones Terminated 3333 Jane Doe Active Task table: EE_ID Task_Name Task_Status 1111 Visit Complete 1111 Visit Incomplete 1111 Eval Incomplete 2222 Visit Complete 2222 Visit Complete 2222 Eval Complete 3333 Visit Complete 3333 Visit Incomplete 3333 Eval IncompleteSolved998Views2likes4Comments