Forum Discussion

bhelou's avatar
bhelou
Responsive Resident
5 years ago
Solved

Lookupvalue Measure

Hello, i have this in a calculated column and working perfect , i need to convert it to a measure 

the search in my report is the transaction number : TRX_Num , i need to see the pay status for each single line in a measure not in columns for performance .


Formula :


Pay_Status =
IF (
ISBLANK (
LOOKUPVALUE (
AWPT_AR_CASH_RECEIPTS_LINES[TRX_NUMBER],
AWPT_AR_CASH_RECEIPTS_LINES[TRX_NUMBER], AWPT_AR_TRANSACTIONS_LINES[TRX_NUMBER]
)
),
"Not Paid",
"Paid"
)
 
 
Thank you very much 
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi bhelou ,

     

    You can use the following measure:

     

    Pay_Status =
IF (
    ISBLANK (
        LOOKUPVALUE (
            AWPT_AR_CASH_RECEIPTS_LINES[TRX_NUMBER],
            AWPT_AR_CASH_RECEIPTS_LINES[TRX_NUMBER], MAX ( AWPT_AR_TRANSACTIONS_LINES[TRX_NUMBER] )
        )
    ),
    "Not Paid",
    "Paid"
)

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

5 Replies

  • negi007's avatar
    negi007
    Community Champion
    5 years ago

    bhelou can you please share your data in text format and the structure of the data. we will then advise you accordinlgy

    • bhelou's avatar
      bhelou
      Responsive Resident
      5 years ago

      Thank you very much , i solved it ,

       

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    Hi bhelou ,

     

    You can use the following measure:

     

    Pay_Status =
IF (
    ISBLANK (
        LOOKUPVALUE (
            AWPT_AR_CASH_RECEIPTS_LINES[TRX_NUMBER],
            AWPT_AR_CASH_RECEIPTS_LINES[TRX_NUMBER], MAX ( AWPT_AR_TRANSACTIONS_LINES[TRX_NUMBER] )
        )
    ),
    "Not Paid",
    "Paid"
)

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

    • bhelou's avatar
      bhelou
      Responsive Resident
      5 years ago

      Thanksss , working great