MS Excel Power Pivot, DAX is not calculating MIN(Year) properly

[xaikus506]

Hello everyone, I would like to ask for your assistance. I would like to generate the calculation similar to the summation of revenue per job with the condition of: 1. per region 2. using the smallest year per region. (for instance in APAC, from 2016 to 2022 it should reflect 2420, LATAM from 2017 to 2022 should be 950 and so forth). Thank you

 

[RoryA]

You need to add an ALL(Year) type condition to your calculate function where you get the min. Otherwise you're only getting the min in the current year context, which is always the same year.

 

[xaikus506]

You need to add an ALL(Year) type condition to your calculate function where you get the min. Otherwise you're only getting the min in the current year context, which is always the same year.

Thank you Rory