Forum Discussion

UmairKamal's avatar
UmairKamal
Icon for Helper I rankHelper I
3 years ago

Lookupvalue bringing invalid dates

Dear Users,   I have a table of payments and a table of cases. although there exists a one to many relationship, RELATED does not seem to be working.   There are multiple payments for the same ca...
Need Help
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
3 years ago

This is a calculated column? or a measure?

Please provide sample data and show the desired result 

  • UmairKamal's avatar
    UmairKamal
    Icon for Helper I rankHelper I
    3 years ago

    This is a caluclated column and not a measure, please see the example with dummy data below, the desired result is in RED.

     

     

  • UmairKamal's avatar
    UmairKamal
    Icon for Helper I rankHelper I
    3 years ago

    I have cracked the code, thank you for your interest and responses.