Need Support in Complex Dax and Visualization filters

[Navaneetharaju_]

Hi Folks, 

@amitchandak , @MFelix , @Anonymous , @Anonymous, @lbendlin,@Ahmedx,@Ritaf1983, @Fowmy , @VijayP 

I want to create a bar chart, it should show what are the tasks going to run on the selected future date. 

I have a data like this:-

Task Table- 

Task_name, Start_date, Start_time, repeat_on, repeat_every, repeat_by

Repeat_by 

Days

Months

Weeks

Year

Repeat_every

1

2

5

10

Repeat_by field that indicates, how frequent the tasks are going to run on daily basis, two days once, weekly basis etc.

Scenario 1 :

Based on above mentioned data, 1st row task(scheduled_omnichannel_BG_Prod_Daily), that task started running on 03/02/2023, from that date onwards it will run daily, if i select 03/03/2023 in my date slicer , this task count should show on 13:00-14:00 time bin.

Scenario 2 :

9thw row task (FORECAST_S_Every_TwiceOnce_SIT), that task started running on 04/18/2023, from that date onwards it running two days once, if i select 04/19/2023 in my date slicer, this task count shouldn't come on that 10:00-11:00 bin.

Scenario 3:

11th row task(PAP_Autofill_Forecast Task), that task started running on 07/20/2023, from that date onwards its running 7 days once, if i select 07/21/2023 in my filter , this task shouldn't come on that 11:00-12:00 time bin. if i select 07/27/2023 in my date slicer, this task should come on that date and the respective time bin.

Like this way , i have a repeat by -weeks, months, year. some tasks running only once in a month, once in a year .

those task should come only on that date.

Please advice, how proceed this and how acheive these scenarios and plot the tasks count in respective time bin based on date.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Navaneetharaju_]

Hi @lbendlin , 

Sample data 

task_name	start_date	start_time	repeat_every	repeat_by
a	3/2/2023	13:20	1	days
b	7/3/2023	22:00	1	days
c	6/26/2023	06:00	1	days
d	3/31/2023	00:30	1	days
e	7/30/2023	06:30	1	days
f	7/24/2023	09:30	1	days
g	7/24/2023	09:45	1	days
h	4/18/2023	10:00	2	weeks
i	4/18/2023	01:00	2	days
j	7/20/2023	11:00	7	days
k	8/11/2023	14:00	3	months
l	9/20/2023	12:00	1	year

Required Slicers- 

Date filter

Repeat_by

Taskname

Visuals should be

Bar chart
X axis - time_bin

Y axis - Count of tasks going to run on the selected date and time

[lbendlin · Accepted solution]

I trust that you can do the count yourself.