Forum Discussion

Fantmas's avatar
Fantmas
Icon for Helper III rankHelper III
3 years ago

Calculation by Row by Year

Hi all, I am trying to create a measure to Dynamically calculate by row a value through year :   In my first table I have the value a & b a is a decimal number b is a integer In a another...
DAX Calculation
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Fantmas 
Please try

Supply =
VAR t =
    SELECTEDVALUE ( Table2[Year] )
RETURN
    SUMX (
        Table1,
        VAR a = Table1[ValueA]
        VAR b = Table1[ValueB]
        RETURN
            a * ( 1 - b ) ^ t
    )