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_...
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

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