User Profile
andrew260z
Frequent Visitor
Joined 6 years ago
User Widgets
Contributions
Unpivot multiple columns that may have nulls
I've been trying to figure out way to unpivot data where an issue / priority and status is split on a delimiter. Each item may have 0..n issues attached to it. Thats been represented in a single column making it hard to determine how many sets of columns there may be. So if 1 item has 3 issues then we will end up with 3 sets of 3 columns with values in them. I've tried to follow https://kohera.be/power-bi/how-to-unpivot-twice/ but end up unpivoting and pivoting back to the same data. The end goal is to end up with a tabular list where an item will have issue the issue listed. Would have no rows if issues did not exist. sample set of data (raw) Item Name Issue(s) C-13501-A1-MH-001 DP01/P1/Closed Out C-13501-N1-U-001 C-13501-N2-D-001 DP01/P1/Closed Out;DP02/P1/Closed Out;DP03/P1/Closed Out C-13501-N3-D-001 C-13501-N4-U-001 DP03/P1/Closed Out Goal data of what one would look like unpivoted. C-13501-N2-D-001 DP01 P1 Closed Out C-13501-N2-D-001 DP02 P1 Closed Out C-13501-N2-D-001 DP03 P1 Closed OutShow non summarised cost
Hi all, been trying to create either a group by or a distinct sum to represent savings for some data Example of the data below - the sum of the final cost is 21,000 but i need to also show the 7,000 (as the consolidatedob coumn would be distinct) and the actual amount paid was 7,000; I've tried a few different ways to do this but it keeps showing me the summarised sum FinalCostSum = SUMX(Distinct('TrackingList Archive'[ConsolidatedOB]),SUM('TrackingList Archive'[Final_Cost])) Should I be doing this with a group by perhaps and linking back to the value CsondolidatedOB?Measure to calculate unlinked amount between 2 tables
Hi Community, just trying to calculate the number of items of a table that are not related but struggling with the concept Tables are 1 to Many [RequestList] 1 ----- * [Candidates] [ID] -------- [RequestID] RequestList has a Status like: Approved Pending Closed What I'm looking to show is of the Approved the number of unlinked Candidates meaning that the request has not had any candidates assigned. And vice versa so there are 2 measures one to show the number linked and other unlinked. Have a rather convuluted way I'm doing it with calculated columns and a distinctcount on the candidates table at the moment but its giving me invalid values. Currently doing where StatusID <> 7 - is recruited: [Candidates] - Measure OpenPositions = CALCULATE(DISTINCTCOUNT(Candidates[DemandID]),Candidates[StatusID]<>7) Then a calculated column in [Recruited] CandidateStatus = LASTNONBLANK(SELECTCOLUMNS(RELATEDTABLE(Candidates),"OpenPos",Candidates[CandidateOpenPos]=1),1) To get a True or False - and i'm doing another calculated column to get the count if True or Not.Falta la columna SPO de Power Query
Tengo un campo de texto vainilla recto en mi lista de SPO que estoy tratando de importar su llamado "DisplayName" no hay evidencia de ello en la consulta de energía en absoluto. No es una columna calculada o cualquier cosa que simplemente contiene texto. Todo lo que se me ocurre es que es el uso de un nombre de columna que PowerBI no puede utilizar? Idealmente no quiero cambiarle el nombre (el código Powerapps tendrá que cambiar) pero supongo que si me veo obligado a hacerlo. Editar; algunas capturas de pantalla para mayor claridad, la columna 'DisplayName' no Editar 2 - He vuelto a comprobar el nombre de la columna de lista en SharePoint y se nombra correctamente, se vuelve a cargar en Powerquery, pero no puede encontrarlo. Me di cuenta de m consulta maneja la nomenclatura de ID - ID.1
