Calculate with filter

Hi,
If I got you right, you trying to calculate SpeScore for latest value.
Unfortunatelly this does not work but there is an easy.

1. In your SPE table, create a calculated column with MAXX and IF, where you specify the latest (period, date, year...)

2. Use your DAX measure, only adjust the condition bit, something like this:

As you can see, I get the value for Period 5, which is the latest.

Please let me know, how did it help!

Hi,
It should work fine, if you use column, which has "Latest" by Company, check this:

The measure then will be a bit adjusted: