Dax error

[vjnvinod]

Hi Experts

see the below error I am getting, how do I modify this code?

[v-zhangti · Accepted solution]

Hi, @vjnvinod 

You can try this to see if it solves your problem.

3M Weightage filter =
CALCULATE (
    MAX ( 'People Flash Consolidated'[Month Rank] ) - 2
        && MAX ( 'People Flash Consolidated'[Weeknumber] )
)

If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?

Best Regards,

Community Support Team _ Charlotte 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener]

Hi @vjnvinod ,

just one & ?