Thanks Alan! I have not used power query formulas before. Is there a way we can just use formula in excel? I will try though.
I really thank you for taking time out and responding.
Mi
In column A I have text like mentioned below. I am trying to separate the City Name and date in two separate columns. I don't need the other text.
Alameda 1-10-20 CSV-PAY SUMMARY RUN.csv
Palm Harbor 1-15-20 Hourly CSV-PAY SUMMARY RUN.csv
Palm Harbor 1-15-20 Salary CSV-PAY SUMMARY RUN.csv...
I am trying to find a formula that will help me add over time. So for example:
Week 1 has 40:36 (Colum A) and Week 2 has 40:36 (Col B) = Regular hours will be 80 (Colum C) and overtime will be 1 hour 12 mins (Colum D). And finally I want to drag the formula down for all.
2nd situation
either...
I have colour coded the colums that I want in each group. When I select those columns and group them at the end of all the columns it just makes one group intead 4 or 5.
I want to group several columns. The problem I face is when I select first 4 columns and group it, it works fine. But when I keep selecting the columns to group them, what happens at the end of the columns is it groups into a one and not separate.
Yes, you are correct if the occupancy declines in future periods it adds up to the prior deficit and if its the surpluse then it will net off with the deficit.
In the attached sheet, I have presented two scenarios, in the first one weekly occupancy reduces and at some point increases and in...
Hello Narayan,
I think the dates are just as an example. We could always change that to month. For now, I am going by those dates in other words weekly. I don't think in calcs its going matter. Unless you are going to add some week or month in the formula. Please see the below logic.
There is...
So this is the method we have to follow -20 + -10 = -30. If we just do 80-100 that just gives us -20 which is wrong. It should be -30 and in that case what you suggested and even my if logic is not correct.
Any ideas how to get the right numbers ?
thanks John. Yes, You could look it either way 80-100 = -20 or 100-90=-10 and 80-90=-10 so -10+(10)=-20.
not sure why I was complicating it. but C2-$b2 looks like its working and other alternative using the If logic is below. I am getting the answers. Pl look below...
In the attached sample spreadsheet I am trying to come up with the running total based on the budgeted number. for example : lets say the total budget is 100 and in month 1 the sales was 90 so there is a deficit of (10), in February the sales was 80 so the deficit has gone up to (20) which is...
Thanks. So finally I was able to get it running but since there are two charts 1) bar 2) trend . Some cities correctly displays the bar chart but doesn't show the trend line. That part is just empty or a dot.
Thanks for the quick response. I will work on it. At my end when I checked of Text Axis in format axis, its able to generate a graph. But your solution looks better. I am gonna try.
Another question is how can I link two data sets in the dashboard for e.g the common factor between two data sets...
I am trying to make a dashboard that shows the trend. I am not able to get a right trend based on the numbers. Please look the attached screen shot. Below is the example
There is a hotel chain named X. X has various locations across the country and its divided in East and West regions. further...
I have a sample data set in the attached sheet. I am trying to covert to a vertical format from a horizontal. There are some guidelines on how I am trying to stack the data in the sample sheet. It will be great if someone can help.
How to convert the below information in a tabular format, i.e each line of row should be a separate column. There is a blank row after each set i.e. (Name, Classroom, Location, Age)
Name
Classroom
Location
Age
Its not 1 but probabably total records of 1000 children.