fact

I have an old file that is in .xls format. When I open it I receive this message Which is fine because I have the password. When I try to remove the password I go to info to choose protect workbook but there is not a password listed and in fact it allows me to create a new password, if I do...

I'm working to make a macro for my accounting team to look at a range of invoices that equal some user defined total. I've seen other solutions even using add-in Solver and none work as well as my version below. (No ego intended) PROBLEM: The problem is, my version below only goes out 4 levels...

I have a Matrix table. There are two Tables, one Fact and another Date and I already linked up so SAMEPERIODLASTYEAR is working I have a problem with Filter Visual in which I want to put 2016, 2017, 2018 buttons which are the three years in FACT table. However, the date in FACT table is date not...

I am using the macro below to protect a worksheet. I am able to filter but I am unable to sort. I wonder if this is due to the fact that it is a table? If I am right how can I correct that? activeSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowSorting:=True...

Apologize in advance if my request seems confusing. I need a formula that indicates the "end date" of when I run out of the content pieces on column F. This is based on the "start date" and the fact that these pieces are distributed only on Monday and Tuesday. I would appreciate it if...

Hi Experts Looking for suggestion on Data model(PowerPivot) with Fact and dimesion for below Fact table on which i need to measure KPI for "ZONE" with filter option on Area and Region [ fact Table ( below is example of 60000 R and 90 C) ] I have create 3 dimension tables 1. Area ( Primary...

I am currently working a workbook that pulls data from a variety of sources. I am using a lot of lookups, which is slowing it down. That is a fix for another time. What I want is for while it is calculating processors, to have a splash screen. I have one currently, but it pulls up after the...

I'm just manually trying to move some shapes around on the active worksheet by selecting the shapes AND then with a Sub move them. IF I in the immidiate window asks for: ? Excel.Selection.Count I get the correct number back ... tried many different selections BUT ...

Hi folks I am trying to write a DAX measure that will return the date of the previous piece of data in a time series. See the example below (UK date format dd/mm/yy): FACT TABLE Date Value PreviousDate 01/03/17 100 03/04/17 200 01/03/17 09/06/17 175...

Hi, I have a fact table (many) and a dimension table (one) with a relationship set up between the two. I have created a matrix that is bringing values (product descriptions) in from the dimension table (as 'Rows'). I have then created a measure using data held exclusively in the fact table...

Hi, I have a fact table - say with 1) description of fruit and 2) with quantity ordered. I would like to take another table of exceptions (ie names of fruits that need to be flagged on fact table). So if "Apples" is a record in the Exceptions table and is also a record in the Fact table, flag...

I have this VLOOKUP and I want to add a condition; The condition is that if the value in column C is "NEW" then I need the cell to be blank. As you can see, I have worked out how to add an error trap but don't know how to add an extra 'IF' condition, if in fact that is possible?

Hi all, The answer I know is 312 x 311 x 310 x 309 x 308 = 2,862,766,146,240 = 2.86277E+12. The arguments are 312 and 5. Using the notation myfunction(x,y) the result is (x)*(x-1)*(x-2)*(x-3)*(x-4)*..etc...*(x-(y+1)) Another example, myfunction(17,10) = 70572902400...