Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
11 months ago
Solved

Max Number per Week

Hi pls need help on how can i have the result i required, on my table from week 1 to current on the result i want to registered 1 if the number is max and 0 if not on the particular week. sample belo...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    11 months ago

    AllanBerces 

     

    You will need to create a new calculated column in your data model to determine if a value is the maximum for its respective week.

     

    Result =
    IF(
    'YourTable'[Count/Trade] =
    CALCULATE(
    MAX('YourTable'[Count/Trade]),
    ALLEXCEPT('YourTable', 'YourTable'[Week])
    ),
    1,
    0
    )

bhanu_gautam's avatar
bhanu_gautam
Super User
11 months ago

AllanBerces 

 

You will need to create a new calculated column in your data model to determine if a value is the maximum for its respective week.

 

Result =
IF(
'YourTable'[Count/Trade] =
CALCULATE(
MAX('YourTable'[Count/Trade]),
ALLEXCEPT('YourTable', 'YourTable'[Week])
),
1,
0
)