Forum Discussion

Pete37's avatar
Pete37
Frequent Visitor
8 years ago

Dynamic % return calculation based on selected date

Dear PBI users, I've recently started using Power BI Desktop and after a few more or less successful simple visualizations I've stucked with something more complex. My inputs are closing share price...
Pete37's avatar
Pete37
Frequent Visitor
8 years ago

Anonymous

I need a range to present it on the line chart. Yes I use Calendar Table to create the slicer.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Pete37,


Change BASELINE_VALUE to the following:

BASELINE_VALUE = 
CALCULATE(
SUM('sheet1'[Closing price]);
FILTER(ALL('sheet1'[Date]);'sheet1'[DATE]<=MAX('date'[Date]) && 'sheet1'[Date]>=MIN('date'[Date])
))



Regards,
Lydia

  • Pete37's avatar
    Pete37
    Frequent Visitor
    8 years ago

    Anonymous

    The new function has too few arguments. I am not sure how to fix it.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Pete37,

      I miss ")" after ALL() function, please check DAX below.

      BASELINE_VALUE = CALCULATE( SUM('sheet1'[Closing price]); FILTER(ALL('sheet1'[Date]);'sheet1'[DATE]<=MAX('date'[Date]) && 'sheet1'[Date]>=MIN('date'[Date]) ))

      Regards,

      Lydia

      • Pete37's avatar
        Pete37
        Frequent Visitor
        8 years ago

        Anonymous

         

        Unfortunately it still doesn't work :( All lines on the chart should start from 0 as at 2017-01-12