Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Custom Column else if divide

Current column is [Days to Close] new custom column is Avg. Days Worked    I would the like formula to say if [days to close] is greater than or equal to 181 then 90 and if [days to close] is less ...
  • lit2018pbi's avatar
    lit2018pbi
    6 years ago

    Anonymous 

    Create a new column using the following DAX

    custom column = IF('Table'[Days] > 501, [Days]/4,IF( [Days]<=500 && 'Table'[Days] >= 180, [Days]/3, IF([Days]<180, [Days]/2)))
     

     

lit2018pbi's avatar
lit2018pbi
Resolver II
6 years ago

Anonymous 

create a new column  as 

Column 2 = IF('Table'[Days] >= 181, 90, IF('Table'[Days] <= 180, 'Table'[Days]/2))