id]

Hi All, I hope someone here can help me out. I've been searching everywhere and cannot find what I need. To explain, I am working on a workbook that has a table within it that contains load of rows of data. This table is called TeamSheetsAll. Within that table are many columns, but relevant...

Hi All, I am using an Index/Match to look up value from another table, and using that data to pivot out average scores. However it is placing zeros in the filed that have no data, which is causing Excel to count that cell. What would I need to do so that a zero value is not returned and...

i have a tables... A B C 1 Employee Id Penalty Counter 2 TA329 A 1 3 TA329 A 2 4 TA329 A 3 How to formulate in cell C, to count how...

Hello All, I am having errors with this line of code: DoCmd.RunSQL "SELECT FAIN, Scope, ALI, Project, [Resource ID],[System Source],Voucher,Vendor,[Vendor Name],[RMB Amount],[UTL Amount],Type INTO CurrentData FROM [Text;DATABASE=C:\Users\C033732\Desktop\CSVFolderPivotTable;HDR=Yes].FFR...

Hello, I am trying to grab reference drawing numbers from another sheet using a design id. In the workbook that I want to add the drawing number to, the design id is formatted as FC1234567899 and in the workbook where I am matching, the design id is formatted as 12345678. The current formula I...

Hi all, I have a rather nifty Dax calculation that gives me everything I need however I need to update it so that it looks at two values in one column than just one. The DAX below Works however there must be a simpler way to do this; Standard 12MR Q018 Positive := CALCULATE ( COUNTA (...

I must have fallen asleep in DAX 101, but I have a tough time testing for RELATED() values that aren't there. Example: We order products that may be substituted by our vendor. We subsequently have to revise our PO to change from the vendor item ID in our item master to the one provided by our...