User Profile
PowerBIGpig
Frequent Visitor
Joined 6 years ago
User Widgets
Contributions
Update Dataset without installing Gateway
Hello! I am under some strict conditions for using PowerBI, and installing the Gateway will not be done without a committee, multiple sacrifices and a sizeable down payment to the IT gods. With that in mind, is there a way to update PowerBI Pro Dataset (which was uploaded from PowerBI Desktop) without the Gateway?Creating a column based on the string value from another table
Hello! I'm having problems... among many, I am trying to create a column in a table that will collect the name from another table and add it into this column... Table 1 (Acc/Act/Comm/Web) Purchase item text Amount WBS ABC.1 item1 230 100001 XYZ 120 100003 random item 450 100003 ABC.1 item2 40000 200001 DEF item 1 200 100002 other random item 100 100002 I have table 2 (Activity List) Work Package Activity WBS Capital WBS ABC ABC.1 100001 200001 ABC ABC.2 100001 200001 ABC UNKNOWN1 100001 200001 DEF DEF.1 100002 200002 DEF UNKNOWN2 100002 200002 XYZ XYZ.1 100003 200003 XYZ UNKNOWN3 100003 200003 I would like to use Activity column in the Activity List table to to search through the string in the Purchase Item Text column to determine which Activity the item relates to, if the Purchase Item Text doesn't have the Activity in the string then the result should be the Unknown# that corresponds with the WBS. I'm hoping for a result such as this: Purchase item text Amount WBS Activity ABC.1 item1 230 100001 ABC.1 XYZ.1 120 100003 XYZ.1 random item 450 100003 Unknown3 ABC.1 item2 40000 200001 ABC.1 DEF.1 item 1 200 100002 DEF.1 other random item 100 100002 Unknown2 Please help!Re: Referencia cruzada a otra tabla para recuperar el valor de texto
Hola @v miembro-msft , La lista de actividades es una lista de todos los códigos PEP/actividad, por ejemplo. Actividad Edt Paquete de trabajo EW.1.1 PROJ-100001 Ew EW.2.1 PROJ-100001 Ew EW.3.1 PROJ-100001 Ew Desconocido1 PROJ-100001 Ew SS.2.2 PROJ-100002 Ss Desconocido2 PROJ-100002 Ss La tabla Acc/Act/Comm/Web tiene todos los artículos comprados, tiene principalmente el WBS (exacto como se indica arriba) y la descripción de la línea que (normalmente) tiene la actividad enumerada en el inicio, por ejemplo, EW.1.1. Si no tiene el nombre de la actividad en la cadena, puede aparecer como desconocido, pero solo si la actividad no está allí.Re: Cross reference another table to retrieve text value
Hi v-lid-msft , The Activity List is a list of all WBS/Activity Codes, e.g. Activity WBS Work Package EW.1.1 PROJ-100001 EW EW.2.1 PROJ-100001 EW EW.3.1 PROJ-100001 EW Unknown1 PROJ-100001 EW SS.2.2 PROJ-100002 SS Unknown2 PROJ-100002 SS The Acc/Act/Comm/Web table has all items purchased, it primarily has the WBS (exact as listed above), and the Line description which (usually) has the Activity listed in the start e.g. EW.1.1. If it doesn't have the Activity name in the string, then it can be listed as unknown, but only if the Activity isn't there.Re: Referencia cruzada a otra tabla para recuperar el valor de texto
¡Hola! Sí, lo dio una buena, y parecía que estaba en camino, estaba contento con las referencias cruzadas a la otra tabla, sin embargo parece ser muy particular en dejar la mayoría de las líneas como "Desconocido" Activity = COALESCE(CALCULATE(max('Activity List'[Activity]), FILTER('Activity List', 'Activity List'[WBS] = 'Acc/Act/Comm/Web'[WBS] && CONTAINSSTRING('Acc/Act/Comm/Web'[Purchasing Item Text], 'Activity List'[Activity]))), "Unknown")Re: Cross reference another table to retrieve text value
Hi! Yes, gave it a go, and it seemed like it was on the way, it was happy with cross-referencing to the other table, however it seems to be very particular in leaving most of the lines as "Unknown" Activity = COALESCE(CALCULATE(max('Activity List'[Activity]), FILTER('Activity List', 'Activity List'[WBS] = 'Acc/Act/Comm/Web'[WBS] && CONTAINSSTRING('Acc/Act/Comm/Web'[Purchasing Item Text], 'Activity List'[Activity]))), "Unknown")Referencia cruzada a otra tabla para recuperar el valor de texto
¡Hola! Estoy tratando de hacer referencia a una tabla que tiene una lista de actividades a una tabla que tiene una lista de compras que "debería" tener las actividades como los primeros caracteres de la descripción. E.g. Tabla de actividades Actividades Edt ABC.1.1 Abc ABC.2.1 Abc DEF.1.1 Def Tabla de compras Edt Descripción Oficina Abc ABC.1.1 Cosas $20 Def DEF.1.1. cosas $33 Abc ABC.2.1 Más cosas $44 Abc Carga $10 Mesa para parecer Edt Descripción Oficina Actividad Abc ABC.1.1 Cosas $20 ABC.1.1 Def DEF.1.1. cosas $33 DEF.1.1 Abc ABC.2.1 Más cosas $44 ABC.2.1 Abc Carga $10 Desconocido1 ¿Hay alguna manera de hacerlo en Power BI Desktop? ¡Gracias!Cross reference another table to retrieve text value
Hello! I am trying to reference a table that has a list of activities to a table that has a list of purchases that "should" have the activities as the first characters of the description. E.g. Table of Activities Activities WBS ABC.1.1 ABC ABC.2.1 ABC DEF.1.1 DEF Table of purchases WBS Description Amt ABC ABC.1.1 Stuff $20 DEF DEF.1.1. things $33 ABC ABC.2.1 More stuff $44 ABC Freight $10 Table to look like WBS Description Amt Activity ABC ABC.1.1 Stuff $20 ABC.1.1 DEF DEF.1.1. things $33 DEF.1.1 ABC ABC.2.1 More stuff $44 ABC.2.1 ABC Freight $10 Unknown1 Is there a way to do this in Power BI Desktop? Thanks!
