Forum Discussion

Adrien_86's avatar
Adrien_86
New Member
2 years ago
Solved

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) ...
Need Help
  • sergej_og's avatar
    sergej_og
    2 years ago

    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)
sergej_og's avatar
sergej_og
Super User
2 years ago

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)
Adrien_86's avatar
Adrien_86
New Member
2 years ago

Yes this is exactly what I'm looking for ! thank you so much !!!

  • sergej_og's avatar
    sergej_og
    Super User
    2 years ago

    You are welcome.
    Have a nice weekend.

  • Adrien_86's avatar
    Adrien_86
    New Member
    2 years ago

    Thanks ! Have a nice weekend