Need Support in Dax Enhancement

[Navaneetharaju_]

Hi @Anonymous  and v-yiruan-msft, 
@AnonymousYou're Excellent,  Thanks for your tremendous support.

I have to one more enhancements from business,

Task name slicer not filtered the data in bar chart. and one more data field has added.

repeat_on - this field applies on days and minutes column.

for example:

TaskA  runs daily and also runs three times per day(15,18,21), so it should disply this time_bin slot also. 

TaskK runs monthly intervel, based on repeat_every field there is one more condition repeat_on have 12, 15 it means it should run every month 12 th and 15th also. if i select 12th Aug 2023 in my date slicer, this task j should come.

TaskJ runs minutes intervel, its run 30minutes once, so task j should  run from the start time every 30 minutes once, that count also we have to find and plot in our time_bin. 

(Note: some task it may runs 5 minutes once also, one hour time slot alone this task run count is 12. it may differs sometime 10 mins etc)

I have new repeat_by - minutes, repeat_every 30 mins 

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

previously https://community.fabric.microsoft.com/t5/Desktop/Need-Support-in-Problem-approaching/m-p/3635138#M1190628,
As per your guidance, i have create Time_bin table and Dax measure. I want to enchance the measure with above scenario's and need to add Task_name field slicer, Repeat_by field Slicer.

Please help me to enhance the dax and also help me to use task_name and repeat_by slicer.

I hope, i explained clearly.

[Anonymous]

Hi @Navaneetharaju_ ,

Based on the information you provided, I need to know if you currently have any other or smaller time units such as hours, seconds. If there are smaller units of time, you need to convert the days, months and years in repeat_by to seconds. Incidentally, when you say minutes, is the time fixed or active?

You can provide more details on what you want to achieve and your final expected output. This will enable us to better solve the problem for you.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Yifan Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

[Navaneetharaju_]

Hi @v-yifanw-msft , 

@v-xinruzhu-msft 

I have provided the details.
can you please help me to get this done. I have running on deadline.

[Navaneetharaju_]

Hi @Anonymous , 

I have to create a task run book report, these tasks are running in different environment and various servers. I have the details of the task_table, it contains taskname, task_id, repeat_on, repeat_every, repeat_by, Server_details, Category.

I want to create a single report with Slicers like Task name, Environment, Repeat_every, Date slicer

Report Visual should be, 

Visual 1 : Matrix or Bar chart - it should contains Task name, Tim_bin, Running task count

Visual 2 : Pie chart - Total_tasks in the table, tasks running on selected date

Visual 3 : Pie Chart - Task_type and Running count on selected date

Visual 4 : Bar Chart - Task_business_category , Running count on selected date

Repeat_by contains only days, Weeks, Months, Minutes, Years only. we don't have any further field there.

And more Task end occurance has added.

task_name	start_date	start_time	repeat_every	repeat_by	repeat_on	End_Occurance	End when
a	03-02-23	13:20	1	days	15,18,21		never
d	3/31/2023	0:30	1	days			never
h	4/18/2023	10:00	2	weeks			never
i	4/18/2023	1:00	2	days	03,06,09		never
c	6/26/2023	6:00	1	days			never
j	7/20/2023	11:00	7	days			never
f	7/24/2023	9:30	1	days			never
g	7/24/2023	9:45	1	days			never
b	07/03/2023	22:00	1	days		5	after
e	7/30/2023	6:30	1	days			never
k	08/11/2023	14:00	3	months	12,15		never
l	9/20/2023	12:00	1	year			never
j	9/20/2023	12:01	30	Minutes		6	after

task running restriction has added now, like
Task B should running daily on 22:00, after 5 days it should not come in our chart.

Task j should running 30 minutes intervel daily, after 6 occurance it should stop. 20 th Sep 2023 - 12:01 it started after 6 runs it should end.

Please provide your support, that will be more helpful.