Max value of the week every day

[Anonymous]

Hi 

Someone can help me with this situation?

I need show the max value of the week every day, is It possible?  What measure I need use?

I put a picture bellow that I need do.

[Jihwan_Kim]

Hi,

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope this can help to provide ideas on how to create a solution for your data model.

Max value of the week measure: = 
VAR _weektable =
    ADDCOLUMNS (
        FILTER (
            ALL ( 'Calendar' ),
            'Calendar'[Start of Week] = MAX ( 'Calendar'[Start of Week] )
        ),
        "@Contagemvalue", CALCULATE ( MAX ( Data[Contagem] ) )
    )
VAR _groupbymaxcontagem =
    GROUPBY (
        _weektable,
        "@maxcontagem", MAXX ( CURRENTGROUP (), [@Contagemvalue] )
    )
RETURN
    IF (
        HASONEVALUE ( 'Calendar'[Start of Week] ),
        MAXX ( _groupbymaxcontagem, [@maxcontagem] )
    )

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

Has your problem been solved by @Jihwan_Kim 's solution, if so, please consider accept his answer as the solution.

You can also try this measure:

Measure =
MAXX (
    FILTER ( ALL ( 'Table' ), 'Table'[Week Num] = MAX ( 'Table'[Week Num] ) ),
    'Table'[CONTAGEM]
)

Best Regards,
Community Support Team _ kalyj

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