Forum Discussion

Broderskap777's avatar
Broderskap777
Frequent Visitor
4 years ago
Solved

Calculate amount based on substring, show value on matching row (in a measure)

Hi,  I am trying to figure out if there is any way to get the row values from one "Transaction Number" to a another "Transaction Number" in the same column. For example, I have a transaction numb...
DAX
DAX FILTER
LOOKUPVALUE
match value
Substring
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    Broderskap777:

     

    New Measure = 
SUMX(
    VALUES('Table'[Transaction Number]),
    VAR _current_tr_num = 'Table'[Transaction Number]
    VAR _correction = "C" & _current_tr_num
    VAR _result = CALCULATE([Amount Measure],'Table'[Transaction Number] = _correction) 
    RETURN
        _result
)

     

     




    Showcase Report – Contoso By SpartaBI


         

Broderskap777's avatar
Broderskap777
Frequent Visitor
4 years ago

hahaha it's amazing how the brain can fail you at times :')

thank you, worked like a charm!