DAX Formulas

[Anonymous]

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.

[v-yulgu-msft · Accepted solution]

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