cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Responsive Resident
Responsive Resident

Lenguaje de fórmulas Power Query M - alternativa a la cláusula SQL IN

¿Cuál es la mejor alternativa de SQL IN mediante el lenguaje de fórmulas Power Query M (no DAX)?

1 ACCEPTED SOLUTION
Super User IV
Super User IV

@Zyg_D , En DAX tiene En

Tabla [Col] en "1","2","3"

Tabla[valor] en el número 1,2,3o

Power Query será

List.Contains('Valor1', 'Valor2', 'Valor3', [Columna1])

recomienda

https://stackoverflow.com/questions/51740679/power-query-m-the-in-operator

https://community.powerbi.com/t5/Desktop/IN-OPERATOR-in-PowerBi/td-p/174285



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
Super User IV
Super User IV

@Zyg_D - En Power Query, hay numerosos ". Contiene funciones" para elementos como List, Table, Text, etc.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Super User IV
Super User IV

@Zyg_D , En DAX tiene En

Tabla [Col] en "1","2","3"

Tabla[valor] en el número 1,2,3o

Power Query será

List.Contains('Valor1', 'Valor2', 'Valor3', [Columna1])

recomienda

https://stackoverflow.com/questions/51740679/power-query-m-the-in-operator

https://community.powerbi.com/t5/Desktop/IN-OPERATOR-in-PowerBi/td-p/174285



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.