RTSK automation

 To find the first occurrence of a date from the "RTSK Closed At" column, where the "RTSK Closed By" is "IPSoft TechUser" for a specific value in "RTSK Task Desc", you can use the following DAX measure in Power BI.

This DAX measure will:

• Filter the data to include only rows where "RTSK Closed By" is "IPSoft TechUser".
• Further filter to include rows where the "RTSK Task Desc" matches the given value.
• Return the first occurrence (earliest date) from the "RTSK Closed At" column.

Here’s how you can write this DAX measure:

DAX
FirstRTSKClosedDateByTechUser = 
CALCULATE(
    MIN('YourTable'[RTSK Closed At]),
    FILTER(
        'YourTable',
        'YourTable'[RTSK Closed By] = "IPSoft TechUser" &&
        'YourTable'[RTSK Task Desc] = "Your specific task desc"
    )
)

Explanation:

• CALCULATE: Modifies the context of the calculation to include only rows that meet the specified conditions.
• MIN: Returns the minimum date from the "RTSK Closed At" column (i.e., the earliest date).
• FILTER: Applies a condition to filter the table.
  • The first condition checks if the value in "RTSK Closed By" is "IPSoft TechUser".
  • The second condition checks if the value in "RTSK Task Desc" matches the specific task description.

Make sure to replace YourTable with the actual name of your table and Your specific task desc with the relevant task description you're targeting.

This will give you the earliest (first) date when the specified task was closed by IPSoft TechUser.