Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Help with column formula DAX

Am trying to create the below column, the column should only populate if there is a number in the Opp open to Opp closed number of days. But it seems it is just doing it for all columns? any help would be amazing 

Need Help
Show and Tell
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    Assume your formula is correct except for the rows where its "Opp open to Opp closed number of days" column is blank.

    You could modify your formula as below

    Column = IF([Opp open to Opp closed number of days]<>BLANK(),[your formula])

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    really hard to see the formula in that screenshot.  Though I did see "Var", and variables are set in the context in which they are defined and not where they are used, so that may be a source of a problem here. But hard to tell without seeing the formula, and even better, some sample data.

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous 

    Assume your formula is correct except for the rows where its "Opp open to Opp closed number of days" column is blank.

    You could modify your formula as below

    Column = IF([Opp open to Opp closed number of days]<>BLANK(),[your formula])

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.