Last seen: Jun 14, 2025
@kasey Thanks! I understand you have some stock listed in "GBPounds" and some in "GBpence". In the Transactions table you could use LET to make i...
@kcrett Always difficult to help without seeing your file, but perhaps this does what you have in mind: =PvTFin!A1:INDEX(PvTFin!A:A,MATCH(2,1/(PvT...
@erik_h_dk I note that you started creating a data model, though am not sure if that's needed just for this purpose. In the attached file, I added a...
@kasey What purpose would a LAMBDA serve in this case? You have some repetition of functions in it that you could avoid with LET, and thus shorten t...
@knutjdahl Not sure I fully understood, but when you want to read out the selection of a slicer you would create a ‘helper’ pivot table as demonstra...
@jubaer007 I must admit that DAX isn't my strongest point and certainly not when it concerns to a rather complicated Changes table that i find in yo...
@navsal66 Can't think of a formula without TEXTSPLIT. I would opt for the Power Query solution, as it's very easy.
@jubaer007 I assume you need help based on the example data in the Data sheet, but please elaborate. There are no slicers. And your initial questio...
@jubaer007 I believe you need to an Employee (fact) table where every employee has a "Date from" that indicates as of when they belong to certain Te...
@navsal66 TEXTJOIN works in E2019, but TEXTSPLIT does not.
@ukdj Oh, sorry. Should have explained better. "Table4 is just the name Excel gave the table when I formatted the data as a structured table. The f...
@karenfry Oh, I hadn't noticed that B had numbers in it and three conditional formats based on these (10, 20, 30). Not sure I though how these tie ...
@karenfry Indeed, you can't 'look-up' color formats. Best to change the template so that column B contains the status in words. Do that with data va...
@univer I would do that with Power Query as demonstrated in the attached file. Edit: Thought of a formula solution as well. Enter the formul...
@ukdj Thanks, that worked. I replaced the formulas in B3 and E8 with ones that create the sequences you had in mind, though without dynamic array fu...