cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Qualube Regular Visitor
Regular Visitor

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Qualube Regular Visitor
Regular Visitor

Re: IF statement

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 5
Anonymous
Not applicable

Re: IF statement

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 Regular Visitor
Regular Visitor

Re: IF statement

Hi T

 

The problem is I get this error message:

 

ERROR.JPG

 

 

Re: IF statement

Is Difference a calculated column or a measure?

Qualube Regular Visitor
Regular Visitor

Re: IF statement

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

Qualube Regular Visitor
Regular Visitor

Re: IF statement

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