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 the "ACTIVE" or "INACTIVE" status.

So if the customer's difference is zero or below I would like them to be "INACTIVE" and the reverse if they have purchased.

The idea is that a sales executive can quickly see all their customer who have been inactive over the past quarter.

 

Thanks in anticipation.

 

 

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

5 Replies

  • 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:

       

       

       

  • Qualube's avatar
    Qualube
    Helper II
    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