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

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Pete37,

    Could you please share your PBIX file to me? I will check it in my environment. And you can share your PBIX file via Private Message.

    Regards,
    Lydia

  • Pete37's avatar
    Pete37
    Frequent Visitor
    8 years ago

    Is there anyone else who could help me with this issue?