Forum

Should be: If InStr(1, "FRZ, FREEZER, FREZ, FRE, FREEZ, FR., FREEZETR, FZR, FRS, FEZ, FSD, FS ", cell.Value) > 0 Then

Hi Jerry, You can use the offset function: COUNTA(G:G) will be: COUNTA(Offset(A:A,0,Match(.....)-1) Note that using full columns is not great fo...

Yes, you are right it is my Dimension table that is in the middle of the Star with the 1 attached. The dozen or so Fact tables are the many end of the...

Dear friend, as mentioned in my first post, without seeing a sample file is hard to visualize your structure. It can be done in 5 minutes, but n...

Hi Lloyd, The structure is different indeed, I doubt that you can get the result you want using PQ menu commands, you have to use the Advanced Edit...

CALCULATE(COUNT(BusinessChange[AnyColumnWithoutBlanks],BusinessChange[Status]="Complete") Like in excel sheet formulas, a COUNT can be applied to a...

Probably best to use a PowerPivot table to create this or should I use Dax? DAX is the language used in PowerPivot, they are not alternatives. ...

Hi Paul, Select that cell, press Ctrl+T to create a table. You can load a table directly in Power Pivot, a named cell can be loaded through power q...

With the measure you mentioned, you should receive for Name 2 the date of 3 Jun 2015, the latest one for that Name. You need a second criteria, to ...

Hi Francis, A simple measure should be able to count the completed ones: CALCULATE(COUNT(SourceTable[Measures]),SourceTable[Status]="Complete") ...

Hi Daniel, A code should be able to run, even if you switch to a different user account to the same computer. I do this frequently, I keep code run...

Hi Heleen, What you should have in mind is that each row in a table is a Record. If you add a new column, you can combine the current Record (ro...

Hi Francis, Try Table.Buffer in the previous step. Also, try loading the #"ExchRate" table in memory before adding the column with Table.Buffer,...

Try with less files, see what happens. Try with a custom solution to get data from folder, the automatic process you have used has many issues and ...

Hi Mel, I understand what you need, but you also have to see things from our point of view. You are saying that: "For this I need to use a Comb...