Forum Discussion

gauravnarchal's avatar
gauravnarchal
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Need help with Calculated Column

Hi   I want to create a calculated column to find the days between two dates as below   If the invoice number starts with 9 then onward (Minus) - return else return (Minus) - onward   Date - Ta...
Need Help
Show and Tell
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    gauravnarchal 

    if there is a relationship between two tables, you can try this

    Column = if(LEFT(RELATED(Table1[Invoice No]),1)="9",Table2[Onward]-Table2[Return],Table2[Return]-Table2[Onward])

    pls see the attachment below

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

gauravnarchal 

if there is a relationship between two tables, you can try this

Column = if(LEFT(RELATED(Table1[Invoice No]),1)="9",Table2[Onward]-Table2[Return],Table2[Return]-Table2[Onward])

pls see the attachment below