Forum Discussion

MikeO's avatar
MikeO
Icon for Helper I rankHelper I
8 years ago
Solved

How can I build a relative comparison between rows?

I am tracking our advertisements by start and end date but to determine end date I need to determine start date of the next time an advertisement runs in same the advertising source.   I have alrea...
Need Help
Tips and Tricks
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi MikeO,

     

    Please refer to below formula:

    End Date =
IF (
    'Table1'[Run Number] = 1,
    TODAY (),
    LOOKUPVALUE (
        'Table1'[Adjusted Run Date],
        'Table1'[Source], 'Table1'[Source],
        'Table1'[Run Number], 'Table1'[Run Number] - 1
    )
)

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi MikeO,

 

Please refer to below formula:

End Date =
IF (
    'Table1'[Run Number] = 1,
    TODAY (),
    LOOKUPVALUE (
        'Table1'[Adjusted Run Date],
        'Table1'[Source], 'Table1'[Source],
        'Table1'[Run Number], 'Table1'[Run Number] - 1
    )
)

 

Best regards,

Yuliana Gu

  • MikeO's avatar
    MikeO
    Icon for Helper I rankHelper I
    8 years ago

    Thank you, Yuliana.

     

    That formula worked perfectly.