Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
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
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
Hi T
The problem is I get this error message:
Is Difference a calculated column or a measure?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |