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
    )

Aburar_123's avatar
Aburar_123
Solution Supplier
11 months ago

Hi AllanBerces ,

 

Please try this calculated column

Flag =
var Max_value = CALCULATE(MAX('Table'[Count/Trade]),FILTER('Table','Table'[Week]=EARLIER('Table'[Week])))
return if(Max_value='Table'[Count/Trade],1,0)