Forum Discussion
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 ...
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 Thank you, I am using M code. My formula changed and this is what I have entered. I am still getting the "Token Else expected" error.
custom column=if[Days to Close]>501 then [Days to Close]/4 else if [Days to Close]<=500 then [Days to Close]/3 else if [Days to Close]<180 then [Days to Close]/2
Do you think this would be easier in DAX?
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)))