Forum Discussion

KoenStam's avatar
KoenStam
Regular Visitor
8 years ago
Solved

Flexible indexed values

(A) I have a relatively simple table with 2 column, one for the date and one containing daily market prices (of aluminium). (B) I made a graph showing the daily prices over the time period covered b...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    KoenStam,

     

    You may add a measure as shown below.

    Measure =
DIVIDE (
    SUM ( 'Primary Aluminium'[Close] ),
    CALCULATE (
        SUM ( 'Primary Aluminium'[Close] ),
        FIRSTDATE ( ALLSELECTED ( 'Primary Aluminium'[Date] ) )
    )
)
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

KoenStam,

 

You may add a measure as shown below.

Measure =
DIVIDE (
    SUM ( 'Primary Aluminium'[Close] ),
    CALCULATE (
        SUM ( 'Primary Aluminium'[Close] ),
        FIRSTDATE ( ALLSELECTED ( 'Primary Aluminium'[Date] ) )
    )
)
  • KoenStam's avatar
    KoenStam
    Regular Visitor
    8 years ago

    Many thanks, your reply solved my question!