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)))
     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

let's consider your column name is days_close.

 

You can try this DAX in your calculated columns using Divide function,

 

=if([days_close]>=181, 90, if([days_close]<=180, Divide([days_close],2),0))