Forum Discussion
Rolling performance measure
Hello everyone,
I'd like to ask you about a little problem I'm having with Power Bi.
I want to create a dynamic graph with the following inputs: dates (x-axis) and sliding performance (y-axis) calculated via a measure.
My problem is with the measure. Using the latter, I want to calculate the performance of an index between 2 dates that can be modified.
The first performance data (the one with the earliest date in relation to the dates selected via the slicer) must always be 100. The other data are calculated as follows (see calculation below and photo of calculation):
(Today's price) / (Last working day's price) * (Last working day's performance)
The problem is that I don't know how to do this using a measure. Does anyone have a solution or any ideas I can explore?
Below are screenshots of what I want to display and the data I'm using.
Thanks in advance for your help 🙂
If it fits your needs try this for your model:
Performance = VAR _MIN = CALCULATE( MIN('Calendar'[Date]), ALLSELECTED('Calendar'[Date]) ) VAR _MAX = CALCULATE( MAX('Calendar'[Date]), ALLSELECTED('Calendar'[Date]) ) VAR _MIN_Value = CALCULATE( [SUM Course], 'Calendar'[Date] = _MIN) VAR _MAX_Value = CALCULATE( [SUM Course], 'Calendar'[Date] = _MAX) VAR _DIVIDE = DIVIDE([SUM Course], _MIN_Value) * 100 RETURN IF( HASONEVALUE('Calendar'[Date]), _DIVIDE)
9 Replies
So you have the smalest date selected by a slicer = Date de debut?
And then you want compare another (random) date selected by a slicer to this earliest date = Date de fin?
Did I get it right?
How do you select these dates?
