Forum Discussion

Diptarup's avatar
Diptarup
Helper II
5 years ago

Dax Calculation

I am new to the PowerBi and would require assistance to solve a problem. I want to get the value of the product A & B based on the second highest year. As shown in the below table ,I want to have a f...
Show and Tell
  • Diptarup's avatar
    Diptarup
    Helper II
    5 years ago

    Hi Selimovd,

     

    Many thanks for your reply.

    I have tried the option that you have said, but not getting the desired result. I am re-phrasing the question, hoping to be clear...

     

    I need to show the lowest value of an activity based on the most recent assesment. Please refer to the below table.

     

    Year             Activity     Value

    1/1/2020          A             3

    1/1/2018           A             5

    1/1/2017          A             2

    1/1/2021           B             1

    1/1/2021           C            15

    1/1/2020            C            2

    1/1/2019           C            6

    1/1/ 2018         D             2

    1/1/2017          D            16

    1/1/2016          D              1

    1/1/2017          E              4

    1/1/2021          f              19

    1/1/2020         G               12

    1/1/2021        H                  1

    I am expecting the output for the lowest values as D -2 (2018), B - 1 (2021), A - 3 (2020) , E - 4 (2017), H - 1 (2021). Please remember the values should be based on the latest assessment for each activity.  Any help will be highly appreciated.