Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Iryna_Khomenko
Regular Visitor

Need to identify repeating tasks within a 30 day period

Dear experts, 

 

Can you please help me with this: I have a table with tasks IDs, their end dates, machines(projects we call them) that these tasks were done for, technicians who completed those tasks. 

We are tracking the "repetitive" tasks that occur more than once within a month (because that'd mean they have not been done properly the first time around).

I now have the count of those like so: 

Count of repetitive tasks =
    CALCULATE (
        SUMX ( FILTER ( 'Dim - Project', [Count of tasks] > 1 ), [Count of tasks] ))
But I need more information about the tasks, not just the count (the technician, for one). What I am thinking now is that I need to rank them by order of their end dates within the past 30days. So that I could see who's done it the first time, who's done it the second time, etc. Please advise. Also there's this 30 days rolling window - current solution "cuts" the calculations at the period selected in the slicer (if it's 2023.01 - then all that happens within Jan), but I need to rebuild it so that it evaluates the tasks for each day of Jan - 30 days, i.e. the task that appears first time in Jan could in fact be repetitive because it's been already done at the end of December so I need to count it as a repetitve task in Jan. The task IDs are unique, so they don't repeat, whether they are repetitive or not we define as follows: if it was done to the same "project" within 30days. In advance, HUGE THANKS!
1 REPLY 1
Iryna_Khomenko
Regular Visitor

I redesigned the approach to this issue. Please see the sample of data below. What I need now is to add three columns: previous end date, previous idd_tk_user, and time difference (current row's End Date - Previous End Date) that would add a previous idd_tk_user, a previous End date, and the time difference between end dates if the task type title is not "Filling the vending machines". So we find the latest non-vending task for the selected project and map to it the end date and the user for the previous non-vending task. In advance, thank you kindly!

Iryna_Khomenko_0-1677746756739.png

 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.