Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

DAX Formulas

Hi Guys

 

I am trying to create a calculated column based on a number of different dependancies;

In order to determine if an opportunity requires a Concept of System document, the opportunity needs to:

 

be at 1 of 5 milestones i.e. [sign off], [approval], [agreemnet] etc.

be either a change renewal or new business

 

and the opportunity must also meet 2 other set criteria for it to qualify.

 

From what i can see it is a mix of AND + OR statements.

 

Any help appreciated.

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anonymous,

     

    Based on current description, it's hard to imagine your data structure and provide detailed advice. To apply filters with a mix of AND + OR statements, you can create DAX formula similar to:

    Measure=CALCULATE(expression1,FILTER(table, Filter1&&(Filter2||Filter3)))

     

    For more advice, please provide sample data and show us desired output. How to Get Your Question Answered Quickly

     

    Best regards,

    Yuliana Gu

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

     

    Based on current description, it's hard to imagine your data structure and provide detailed advice. To apply filters with a mix of AND + OR statements, you can create DAX formula similar to:

    Measure=CALCULATE(expression1,FILTER(table, Filter1&&(Filter2||Filter3)))

     

    For more advice, please provide sample data and show us desired output. How to Get Your Question Answered Quickly

     

    Best regards,

    Yuliana Gu