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.
I need help. We are running a promotion and identifying how many new customers have used the promotion.
A calculated column (Conversion) was created with a DAX Formula of:
Conversion =
VAR _FirstOrder = Sheet1[ORDER RANK] = 1
VAR _Promo = Sheet1[First_ORDER_PROMOTION] = "Yes"
RETURN
IF( _FirstOrder && _Promo , "Converted", "")
Now, I need to create another column where I can identify who amongst the customers who were "converted" submitted another order. In this table, customers A, B, and E who were converted already had their 2nd order. I need to create a calculated column and have them tagged as converted to second.
DESIRED OUTPUT:
Solved! Go to Solution.
@Andrew_na_lang calculated column
Column =
IF (
'fact'[orderRank] = 2
&& ISBLANK (
TOCSV (
INDEX (
2,
ALL ( 'fact'[pickupDate], 'fact'[custID] ),
ORDERBY ( 'fact'[pickupDate], ASC ),
KEEP,
PARTITIONBY ( 'fact'[custID] )
),
100,
","
)
)
= FALSE (),
"Converted to Second"
)
@Andrew_na_lang calculated column
Column =
IF (
'fact'[orderRank] = 2
&& ISBLANK (
TOCSV (
INDEX (
2,
ALL ( 'fact'[pickupDate], 'fact'[custID] ),
ORDERBY ( 'fact'[pickupDate], ASC ),
KEEP,
PARTITIONBY ( 'fact'[custID] )
),
100,
","
)
)
= FALSE (),
"Converted to Second"
)
try like:
try like:
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |