Max count of stock for every week

[AndreaManfredi]

Hello,

I have a dataset that looks like this way:

several levels of pieces (VAN) counted, that represent stock registered on any single day

a specific day (report date)

the related week (report date week)

Report Date.week | Report Date | Count(VAN) 

W01                          01/01/24         3373

W01                          03/01/24         4581

W01                          05/01/24         5285

W01                          06/01/24         2536

W02                          09/02/24          1853

W02                          10/02/24           5738

W02                          12/01/24          3752

W03                          15/01/24          2784

W03                          18/01/24          1836

W03                           19/01/24          5184

W03                            20/01/24         3284

what I need is to have in this table, only the max count of van for each week: as a result, I should have only one day per every week, when the maximum count of van is registered 

thank you for the help! 

[Anil_Babu_Samineni]

@AndreaManfredi Perhaps this in your measure with other two as dimensions?

Max(TOTAL <[Report Date.week]> [Count(VAN)])