xlookup
3 Topics
Add column to Power Bl tab where value is from another row in table where 3 columns match criteria
In the table below, records 1,2,3,5 DAX formula copies city names from Town to the Missing Town as data was already available. New Column Number First Name Second Name Birthday Visits Distinct Town Missing Town 1 Jack Dee 16/06/2011 0 2 London London 2 Paul Jacob 01/07/2014 0 1 Paris Paris 3 Peter James 07/03/2015 1 2 Madrid Madrid 4 Viktors Thomas 27/12/2008 1 1 5 Eliana Plumb 05/02/2012 1 1 Miami Miami 6 Kausar Defoe 10/10/2008 0 1 7 Khadija Singh 19/11/2011 1 1 Tokyo Miami 8 Krish King 24/07/2008 0 1 9 Ibrar Plaice 02/09/2011 1 1 10 Nash Chow 07/05/2008 0 1 11 Jack Dee 16/06/2011 1 2 London 12 Ahmad Santosh 19/02/2008 0 1 13 Peter James 07/03/2015 0 2 records 4,6,8,9,10,12 and 13 do not have the Town and as there are no other matching records with Town that meet the 3 criteria First Name, Second name and Birthday , so DAX formula will leave them empty on the Missing Town Column, unless we can find another record that matches the 3 cirtiera. DAX formula is needed for 'Missing Town' column so Record 11 can pull Town into the Missing Town column from record 1 that matches the 3 criteria which has the Town. Hope that helps claridy what I am trying to do, bnasicall pupulating a colum if the data is available in one ofthe other records in the table if 3 criteria are met.Solved1.5KViews0likes6Comments
HOW TO BRING VALUE FROM ONE TABLE TO ANOTHER TABLE IN NEW COLUMN WITHOUT TABLE RELATIONSHIP IN DAX
Hi I have two tables.. TABLE 1 (DocNo, DocEntry, DocTotal, Date, Misc...) TABLE 2 (DocNo, DocEntry, DocTotal, Date) I want to pull Doc Total of TABLE 2 into TABLE 1 for Matching DocEntry field. But there is not relationship between two tables. So how to do that with DAX?Solved1.3KViews0likes3Comments
DAX equivalent of XLOOKUP function in Excel
Is there a way to duplicate the XLOOKUP function in DAX? In my excel file, if the number of photos=0, then I need to look for the next date where the number of photos is greater than 0, and assign the Tier Lookup to the dates prior. The desired result is shown in column I. Thank you!23KViews0likes5Comments
