Forum Discussion

jayjay0306's avatar
jayjay0306
Icon for Helper III rankHelper III
6 years ago
Solved

Power BI filter - Latest forecast version

Hi people, I am in a bit of a puzzle here and hope you guys can help: I have the following table showing our forecast version: Our forecast process works in the following way: On the first ...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi jayjay0306 ,

     

    You could share your expected result here with image or table.

    And you could try the following DAX:

    Table 2 =
SUMMARIZE (
    'Forecast',
    'Forecast'[SOP Version],
    "LAG (lowest value)", CALCULATE (
        SELECTEDVALUE ( Forecast[LAG] ),
        FILTER (
            Forecast,
            RIGHT ( Forecast[LAG], 1 ) = MINX ( Forecast, RIGHT ( Forecast[LAG], 1 ) )
        )
    )
)

     

v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi jayjay0306 ,

 

You could share your expected result here with image or table.

And you could try the following DAX:

Table 2 =
SUMMARIZE (
    'Forecast',
    'Forecast'[SOP Version],
    "LAG (lowest value)", CALCULATE (
        SELECTEDVALUE ( Forecast[LAG] ),
        FILTER (
            Forecast,
            RIGHT ( Forecast[LAG], 1 ) = MINX ( Forecast, RIGHT ( Forecast[LAG], 1 ) )
        )
    )
)

 

jayjay0306's avatar
jayjay0306
Icon for Helper III rankHelper III
6 years ago

thanks v-eachen-msft, it got me the rest of the way 🙂

Br,

JayJay0306