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

Hi Anonymous ,

 

 

In M Code

Custom Column=if [Days to Close]>=181 then 90 else if [Days to Close]<=180 then [Days to Close]/ 2

 

 

In DAX (Calculated Column)

 

Column =
SWITCH(
TRUE(),
Table[Days to Close] >= 181 , 90,
DIVIDE(Table[Days to CLose],2)

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)