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
Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Diptarup 

Please check the below picture and the calculated measure, whether it is what you are looking for.

 

 

Ranktwo Activity =
IF (
RANKX (
ALLSELECTED ( Products[Year] ),
CALCULATE ( MAX ( Products[Year] ) ),
,
DESC
) = 2,
SUM ( Products[Activity] ),
BLANK ()
)

 

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Diptarup's avatar
Diptarup
Helper II
5 years ago

Hi Jihwan,

 

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.