Last seen: Jun 25, 2026
@dave_uk Glad I could help
@dave_uk I believe you need the MAX of two MAXIFS and the MIN of two MINIFS. I've added them to your file. Note that I prefer to work with structure...
@hutchdjr How exactly? Numbers in one column and the codes in the next column filled down, or just in the same row? Perhaps the attached file will...
@erik_h_dk Glad i could help!
@kasey OK, so you want the total realised (sell) and unrealised (no sell) results. Then I suggest you insert a column that calculates the quantity ...
@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.