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
    8 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

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