One table Vlookup equivalent in DAX
Dear community, I'm trying to get shipment C013720578 to be shown in column Group for all rows. Shipment C013720578 is the main shipment, out of 4 shipments linked to invoice 1891846520. I need to do this for all Invoices in column Invoice. My first try was lookupvalue Column = LOOKUPVALUE('BRIDGE FULL'[Shipment],'BRIDGE FULL'[Invoice & main],'BRIDGE FULL'[Invoice & Shipment Type]) This wouldn't work becuase there are duplicates (in the Search Value I think), and I got this error: A table of multiple values was supplied where a single value was expected. How do I modify the formula below please? or something completely different? (hint: shipment C012293295 currently shown in column Group is the very first shipment of the entire big table) Invoice Shipment Shipment Type Shipment Type - Main Invoice & main Invoice & Shipment Type Group 1891846520 C013720583 ZT13 not main 1891846520main 1891846520not main C012293295 1891846520 C013720577 ZT11 not main 1891846520main 1891846520not main C012293295 1891846520 C013720579 ZT13 not main 1891846520main 1891846520not main C012293295 1891846520 C013720578 ZT12 main 1891846520main 1891846520main C012293295 1891846523 C013720577 ZT11 not main 1891846523main 1891846523not main C012293295 1891846523 C013720579 ZT13 not main 1891846523main 1891846523not main C012293295 1891846523 C013720586 ZT13 not main 1891846523main 1891846523not main C012293295 1891846523 C013720578 ZT12 main 1891846523main 1891846523main C012293295 1891846524 C013720579 ZT13 not main 1891846524main 1891846524not main C012293295 1891846524 C013720586 ZT13 not main 1891846524main 1891846524not main C012293295 1891846524 C013720577 ZT11 not main 1891846524main 1891846524not main C012293295 1891846524 C013720578 ZT12 main 1891846524main 1891846524main C012293295
DAX Vlookup with multiple values and contains logic
I need to filter TableB of IDs based off a slicer for one of the TableB[ColumnC] column values. Then take IDs from TableA and if those IDs are in the new subset of TableB IDs, grab TableB[ColumnB]. Here is where I'm stuck on the DAX: If more than one value is selected from the TableB[ColumnC] slicer, then the IDs can be repeated with more than one TableB[ColumnB] occurence. TableB[ColumnB] options are "Web" and "Other" if there is more than one occurence, then I need a new DAX logic if any results contain "other" then the final result is "Other". if the results only contain "Web", then "Web" To view the subset of TableB IDs from the slicer selection, I have: WEB IDs = VAR FilterSels = VALUES(FilterTable[Source]) VAR FilterPIDs = CALCULATETABLE( VALUES(FilterTable[PID]), FilterTable[Source] in FilterSels, FilterTable[Source Origin] = "Web" ) // view the list of PIDs left after source selection Var Concat = CONCATENATEX( FilterPIDs, FilterTable[PID], UNICHAR(10), FilterTable[PID] ) RETURN Concat Then I have the same DAX to check the "Other". How do I combine these IDs into one check table, then check the IDs from TableA, then run a VLOOKUP with multi results, then a if result Contains logic? Test Logic PBIX Excel Data and Calculations
Column Comparison - Vlookup
I have two columns I need to compare, one column: 'MOM Stocking Report': Shows all stocked items & 'Demand Seg': Shows the complete list of purchased items. I need to compare them against one another to know which ones are stocked and which are not. As you can see the equation below, it appears to get me halfway there as the pie chart does capture the data, however I am not certain this is correct, Also when I click on the 'YES' stocked pie chart, the table shows nothing. Also, technically the 'Agreement Level' should be a 0 if 'Not Stocked' or come back with null. My relationship cardinality is at Many to Many , it wont let me change- I have removed all duplicates from Power Query. So I am basically out of ideas: My Stock or Not Equation: Stocking Agreement? = if(isblank(countx(filter('MOM Stocking Report','MOM Stocking Report'[Item Number]='Demand Seg'[ITEM NUMBER]),'MOM Stocking Report'[Item Number])),"YES","NO")How to recreate this in Power BI - IF(VLOOKUP)= "var" IF(VLOOKUP)
Hello, I have this formula from Excel that I am trying to replicate in Power BI in either Power Query Editor or as a Measure. Excel formula: =IF(VLOOKUP(I92436,references!A:C,3,FALSE)="BVX",IF(J92436<references!$F$2,"BVX","WC-BVX"),VLOOKUP(I92436,references!A:C,3,FALSE)) I have 3 datasets I'm connecting to, 2 reference tables that mirror the reference tab in the above Excel and the main dataset, also mirroring the above Excel dataset. What I have so far in Power BI, I did this as a Measure, since Power Query Editor didn't give many options. Location = LOOKUPVALUE(Scraps[LOCATION_NO],'Reference Table'[Summary 2],TRUE(),'Reference Table'[Beavex transition date].[Date]) RETURN IF((Scraps[DATE_APPLIED] < 04/26/2019, "BVX","WC-BVX"),LOOKUPVALUE(Scraps[LOCATION_NO],'Reference Table'[Summary 2])) Any help would be greatly appreciated. Thank you, Dusty2 Tables _ Combine _ RANKX
Hi guys, I have a quick question, maybe you can help. Table 1 Code Plan Group Arrival date other column 1 CCC/a Windows 1/1/2020 2 CCC/a Windows 1/1/2020 3 CCC/a Lock 1/1/2020 101 CCC/a Lock 1/1/2010 203 CCC/b Door 2/1/2010 205 CCC/b Door 2/1/2010 206 CCC/b Door 2/1/2010 205r BBB/a 2/1/2010 Table 2 Plan Group Class Sold Date CCC/a Windows Hard 1/1/2000 CCC/a Lock Medium 1/1/2005 CCC/b Door Medium 20/04/2020 What I can do is to create table visual like this Code Class Sold Date Plan 203 Medium 20/04/2020 CCC/b 205 Medium 20/04/2020 CCC/b 206 Medium 20/04/2020 CCC/b What I would like to do is to do this: Code Class Sold Date Plan 1 Hard 1/1/2000 CCC/a 2 Hard 1/1/2000 CCC/a 3 Medium 1/1/2005 CCC/a 101 Medium 1/1/2005 CCC/a Could you help me with that please ? Plan is calculated column with Rankx.
To get Total in between categories.
Hi, I have a table like this in Sheet 1- And from the sheet 1, I want to create Page 2 in Power BI which is like in Sheet 2 below- Difference is here the Total is populated through Sum formula. Values have been achieved through Vlookup- How I can do the same in Power BI by Exporting Sheet 1 and creating Sheet 2 from Sheet 1. Thanks, Amit KumarLOOKUPVALUE - Compare Text Values in columns to get a date value
Hi... Jihwan_Kim Fowmy amitchandak PaulOlding I am really hoping someone can help me. I have a table in power BI. Column A has the unique Project Number, Column B has an Activity ID. that is unique within the project but not unique otherwise; Column C has the actual start date of the activity in column B; Column D has the predecessor Activity ID (unique within the project but not unique otherwise). What I am trying to do is compare Column D (Predecessor Activity ID) to Column B (Activity ID) within the same project (Column A) and return the Actual start date of the Predecessor Activity in Column E.... I cannot figure of the proper DAX expression and everytime I try it tells me it can't retun a date based on text columns. This is the result I am looking for but in PBI.... Any help would be really appreciated!
