Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Comienza con la pregunta

Tengo una medida Ventas Totales (Ventas[Ventas])

Si el nombre del cliente comienza con "Acme" reduce Sales[Sales] en un 12%, si el nombre del cliente comienza con "Vect", reduzca SALES[Sales] en un 10%, si el nombre del cliente comienza con "Merc", reduzca SALES[Sales] en un 9%, de lo contrario sum(SALES[Sales]).

1. ¿Sería más eficiente agregar una columna en la tabla VENTAS llamada [Ventas ajustadas] que calcula este cálculo, luego crear una nueva medida Total de Ventas Ajustadas -sum(VENTAS[Ventas Ajustadas]), o simplemente hacer este cálculo con una medida?

2. Cualquiera que sea más eficiente, ¿cómo lo escribiría? La columna estaría en idioma M y la medida estaría en DAX y no estoy seguro de cómo escribir esta fórmula en cualquiera de los dos.

Gracias por tu ayuda.

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@Usates Recomendaría crear una columna con ventas ajustadas y luego usar esta nueva columna en las medidas

Adjusted Sales Column = 
VAR __start = LEFT ( Table[Customer], 4 )
RETURN
SWITCH ( __start,
 "ACME", .88,
 "VECT", .90,
 "MERC", .81,
1
) 
*
Table[Sales]


Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

2 REPLIES 2
parry2k
Super User
Super User

@Usates Recomendaría crear una columna con ventas ajustadas y luego usar esta nueva columna en las medidas

Adjusted Sales Column = 
VAR __start = LEFT ( Table[Customer], 4 )
RETURN
SWITCH ( __start,
 "ACME", .88,
 "VECT", .90,
 "MERC", .81,
1
) 
*
Table[Sales]


Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

amitchandak
Super User
Super User

@Usates ,

Trate como

sumx(VENTAS,
Switch( True(),
left((SALES[customer]),4) á "Acme" , SALES[Sales] *.88,
left((SALES[customer]),4) á "Vect" , SALES[Sales] *.90,
left((SALES[customer]),4) á "Merc" , SALES[Sales] *.9,
VENTAS[Ventas])
)

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Top Solution Authors
Top Kudoed Authors