Forum Discussion

Navaneetharaju_'s avatar
Navaneetharaju_
Helper II
2 years ago
Solved

Need future dates based column condition

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

 

TaskRun datesrepeat byrepeat every
Fetch_data_from_sql_aws01-12-23days3
Fetch_data_from_sql_aws04-12-23days3
Fetch_data_from_sql_aws07-12-23days3
Fetch_data_from_sql_aws10-12-23days3
Fetch_data_from_sql_aws13-12-23days3
Fetch_data_from_sql_aws16-12-23days3
Fetch_data_from_sql_aws19-12-23days3

      

 

 

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.

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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