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.
Aquí está mi declaración de caso en SQL
CASO CUANDO T4. SALES_CHANNEL IN (X,Y,Z) ENTONCES SUM(T3. CUSTID)/SUM(T2. TRANID)
ELSE SUM(T1. TICKETID)/SUM(T2. TRANID)
ELSE 0 END AS NEW_RATIO
Empecé con este DAX, pero no puedo conseguir el cambio o SI trabajo aquí
NEW_RATIO- DIVIDE(SUM(T1. TICKETID),SUM(T2. TRANID),0)
Solved! Go to Solution.
Tratar
•If(T4[SALES_CHANNEL] IN ?X,Y,Z',divide(SUM(T3[CUSTID]),SUM(T2[TRANID])),divide(SUM(T1[TICKETID]),SUM(T2[TRANID])))SUM(T1[TICKETID]),SUM(T2[TRANID])))
Tratar
•If(T4[SALES_CHANNEL] IN ?X,Y,Z',divide(SUM(T3[CUSTID]),SUM(T2[TRANID])),divide(SUM(T1[TICKETID]),SUM(T2[TRANID])))SUM(T1[TICKETID]),SUM(T2[TRANID])))
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 |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |