Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I need date field as a result
I have one start date, pipeline run schdules.
Start date = 01/12/2023
Repeat by - days
repeat every - 3 (3 days once)
Task name - Fetch_data_from_sql_aws
I want this task next run dates till today
Task | Run dates | repeat by | repeat every |
Fetch_data_from_sql_aws | 01-12-23 | days | 3 |
Fetch_data_from_sql_aws | 04-12-23 | days | 3 |
Fetch_data_from_sql_aws | 07-12-23 | days | 3 |
Fetch_data_from_sql_aws | 10-12-23 | days | 3 |
Fetch_data_from_sql_aws | 13-12-23 | days | 3 |
Fetch_data_from_sql_aws | 16-12-23 | days | 3 |
Fetch_data_from_sql_aws | 19-12-23 | days | 3 |
I want these run date as a result. like above i have multiple tasks run on daily basis, weekly once, monthly once, I have start date now i have to find the upcoming days when this gonna run.
Thank you.
Solved! Go to Solution.
Hi @Navaneetharaju_ ,
You can create a measure as below to get it:
Next run dates =
VAR _maxdate =
CALCULATE ( MAX ( 'Table'[Run dates] ), ALLSELECTED ( 'Table' ) )
VAR _repeatday =
CALCULATE ( MAX ( 'Table'[repeat every] ), ALLSELECTED ( 'Table' ) )
RETURN
_maxdate + _repeatday
Best Regards
Hi @Navaneetharaju_ ,
You can create a measure as below to get it:
Next run dates =
VAR _maxdate =
CALCULATE ( MAX ( 'Table'[Run dates] ), ALLSELECTED ( 'Table' ) )
VAR _repeatday =
CALCULATE ( MAX ( 'Table'[repeat every] ), ALLSELECTED ( 'Table' ) )
RETURN
_maxdate + _repeatday
Best Regards
User | Count |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |