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's avatar
Anonymous
Not applicable
8 years ago

Pete37，

Do you need to select data range or single date value in the date slicer? And do you use Date field of calendar table to create the slicer?

Regards,
Lydia

  • 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.