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