Forum Discussion
Need Support in Complex Dax and Visualization filters
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.
I trust that you can do the count yourself.
3 Replies
- lbendlin
Super User
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-Forum/ba-p/963216
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/1447523- Navaneetharaju_
Helper II
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 beBar chart
X axis - time_binY axis - Count of tasks going to run on the selected date and time
- lbendlin
Super User