Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to combine Lookupvalue, If and AND statement.

Hello, I have a problem that I tried to look for in this discussion as well, but I couldn't find anything that could help me.   I would like to create a function that would compare the columns Un...
Need Help
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    Hi Anonymous ,

     

    Your current DAX formula doesn't affect your memory and Ithink you've solved your problem.

     

    Best regards,

    Yadong Fang

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

v-yadongf-msft's avatar
v-yadongf-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Anonymous ,

 

Please try following DAX:

Column = SWITCH(
    TRUE(),
    'Table'[Index] = 0 &&'Table'[Index] = 1 &&'Table'[Index] = 2 
    && 'Table'[Index] = 3 &&'Table'[Index] = 4 && 'Table'[Index] = 5 
    && 'Table'[Uncleansed sales history] > 'Table'[Statistical FC LC Lag 1],
    "Overforecast last 6 months",
    BLANK())

 

Best regards,

Yadong Fang

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi About v-yadongf-msft,

     

    thank you for your answer, but it is not working. I finally managed to do it, but I had to create too many auxiliary calculated columns where. I'll send you a photos of my process step by step. 

     

    As I already wrote above
    I would like to create a function that would compare the columns
    Uncleansed sales history and Statistical FC LC Lag 1 for the last 6 months.

    f the condition is true for all 6 rows
    Row(index) 0 Uncleansed sales history > Statistical FC LC Lag 1
    Row(index) 1 Uncleaned sales history > Statistical FC LC Lag 1
    Row(index) 2 Uncleansed sales history > Statistical FC LC Lag 1
    Row(index) 3 Uncleansed sales history > Statistical FC LC Lag 1
    Row(index) 4 Uncleansed sales history > Statistical FC LC Lag 1
    Row(index) 5 Uncleansed sales history > Statistical FC LC Lag 1

     

    return "Overforecast last 6 months"

    if this condition does not apply to at least one, return me "blank"

    so what i did

    1. Step)

    2.Step

    3. Step

     

    Is there any way to make it easier and save memory?

    Thank you