Need future dates based column condition

[Navaneetharaju_]

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.

[v-yiruan-msft · Accepted 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