Actual target value

[Elmarius123]

Greetingd Actually, i have a Target value.. this target value should change regarding of month, say in october Target value was 45%, in December it is changed to 65%. When i select November, there should be shown acting Limit, which is 45%(October).

How to write a measure?

[v-yanjiang-msft · Accepted solution]

Hi @Elmarius123 ,

According to your description, I create a sample.

In my understanding, for the months have no Target, your expected result is to display the target of the most recent month before, here's my solution.

Create a measure.

Actual target =
IF (
    MAX ( 'Table'[Target] ) <> BLANK (),
    MAX ( 'Table'[Target] ),
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Index]
                = MAXX (
                    FILTER (
                        ALL ( 'Table' ),
                        'Table'[Index] < MAX ( 'Table'[Index] )
                            && 'Table'[Target] <> BLANK ()
                    ),
                    'Table'[Index]
                )
        ),
        'Table'[Target]
    )
)

Get the result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Whitewater100]

Hi:

Can you explain further and show some data? Thanks..