Forum Discussion

Qualube's avatar
Qualube
Helper II
8 years ago
Solved

IF statement

Hi   I would like to determine if a particular customer has been active in the last quarter. I have all sales in a column called difference but can't seem to find the right IF statement to return t...
Need Help
  • Qualube's avatar
    Qualube
    7 years ago

    Managed to solve it after looking extensively on the web with a new measure:

     

    InactiveCustomers = CALCULATE( COUNTROWS( 'Customer List Table' ), FILTER( ALL('Customer List Table'[Difference]), 'Customer List Table'[Difference] <= 0 ))

     

    Thanks for the help anyway

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Qualube,

 

Do you want to this in DAX or in Power Query?

 

In Power Query:

if [difference]<=0 then "INACTIVE" else "ACTIVE"

 

In DAX:

IF(table[difference]<=0, "INACTIVE", "ACTIVE")

 

Br,

T

 

  • Qualube's avatar
    Qualube
    Helper II
    8 years ago

    Hi T

     

    The problem is I get this error message:

     

     

     

    • Caitlin_Knox's avatar
      Caitlin_Knox
      Advocate III
      8 years ago

      Is Difference a calculated column or a measure?

      • Qualube's avatar
        Qualube
        Helper II
        8 years ago

        Hi Caitlin

         

        It's a measure as what I need to do is filter through the [difference] column and return the number of customers with zero or negative sales over a quarter.

        I have looked extensively and I think SUMX is the expression I need to use but I can't make it work.

         

        Thanks