• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Blanks in Power Pivot table

    I have problems with my file that you wrote the measures for 2 years ago. I get the following error message but cant solve the problem. Are you willing and able to help. Thanks,
  2. A

    Column to calculate cost of unit

    I figured it out by using a helper table by power query that contained only those invoice numbers with BOXING or COLD HOT. Then using IF and SUMIFS to get the correct price per unit. Thank you for looking.
  3. A

    Column to calculate cost of unit

    I want to calculate the cost of a plant based on what the total costs to buy that plant from a supplier. I have attached a workbook with what I am working that a supplier sent. It is straight forward with most of the items with the exception when BOXING or COLD HOT fee is added in the column...
  4. A

    Blanks in Power Pivot table

    Thank you for sharing the link. Leila Gharani is able to take something complicated and explain it in simple terms and examples. All is working well.
  5. A

    Blanks in Power Pivot table

    Thanks for adding the totals, I was in the process of asking about it when I saw your message. I halfway understand the code you wrote but not fully. It is working well. I will create a new file next week and hope there aren't any problems.
  6. A

    Blanks in Power Pivot table

    I apologize I grabbed the wrong file to upload. The Pivot Table is on Orderstoplant tab. It should be populated. Again, I'm sorry. Thank you.
  7. A

    Blanks in Power Pivot table

    I use Power Query to transform data from Excel files into appends. There are two results that are loaded into the data model and a relationship is created between them. The data model is then loaded to a Power Pivot table. It works well enough but on the Description field on the pivot table...
  8. A

    Weeknum not showing week 1 in 2022

    Thanks Ken, it seems to be the simplest solution. Gig Em! Lee ('81)
  9. A

    Weeknum not showing week 1 in 2022

    That will return the correct week for January 2, 2022 but shifts the other days of that first week into week 2. January 7, 2022 returns a week 2 with the return_type 2. The closest to matching the wall calendar is with return_type 21 but it puts January 2, 2022 into week 52 of year 2021.
  10. A

    Weeknum not showing week 1 in 2022

    I use the formula Weeknum(a1,1) for a date that is January 2, 2022 but it doesn't return week 1 instead it returns week 2. I have tried various other first week dates January 2, 2022 thru January 8, 2022 and it won't return week 1 but week 2. I have used the other return_type handles but can't...
  11. A

    VBA to write a formula in column if cell not empty

    Thank you! It works very well.
  12. A

    VBA to write a formula in column if cell not empty

    I got the code to run but there is a Debug box that returns. The formula should go in the C36 cell. Thank you for being patient with me and helping.
  13. A

    VBA to write a formula in column if cell not empty

    I'm not sure I have done it correctly but I can't get it to work. When I type the item number in A36 it should write the formula in C36 but I can't get it to work. I hope I have included enough for you to see what I've attempted.
  14. A

    VBA to write a formula in column if cell not empty

    I don't know VBA and asking for help on learning VBA to write a formula in column C if the cell in column A is not empty. I have attached a workbook with the formula and the way I am using now is to put the formula in more cells than the user will use. The user may add comments to explain what...
  15. A

    Countifs in a table to return payroll of that year

    Thank you vletm for the solution. It works well. I don't understand it but it works. If you have time can you tell me why it works? Could it be done using Unique() to not use the helper pivot table? Thank you.
  16. A

    Countifs in a table to return payroll of that year

    First it was toilet paper and now crystal balls, what is next? Thanks for replying. In the Pay Period column something like this. As long as the Check Yr is the same, place a starting number of 1 in the Pay Period for each matching Check Date and increase that number by one for each change in...
  17. A

    Countifs in a table to return payroll of that year

    I download payroll data then using Get Data transform the raw data into a table with multiple years, 2015 thru 2021. I want to create a column that will tell me what the payroll number it is for that year, 1 thru 26 January 16, 2015 would be payroll 1 for 2015 January 30, 2015 would be payroll...
  18. A

    Relationships in Data Model

    I can't open the attachments. It gives an error message that the attachment can't be found. I am logged into the website. I appreciate your help. Thanks
  19. A

    Relationships in Data Model

    After reviewing the file, the pivot table doesn't add the values correctly. Lee
  20. A

    Relationships in Data Model

    The Full Outer on Item Number worked very well! I wouldn't have ever thought of doing it that way. I always learn so much from the group here. Thank you for taking the time to respond and again the answer was what I was looking for. Lee
  21. A

    Relationships in Data Model

    I would like to use a Pivot Table based on Rows with fields named Update Description # of Crops Sell Date Area & Tables Values based on Finish Units Units Planted Units Booked (from query SPRBKNG18) Filters Cust Name (from query SPRBKNG18) Pot Size Group I thought I could do it using...
  22. A

    Handshake error on mSQL server

    It is fixed but not sure why it is doing this. Reviewed the Data Source Settings but the Encrypt Connections box was unchecked. Checked on my computer and error computer both showed no checked box. The privacy level was set to Organizational but didn't change the setting. Deleted all the...
  23. A

    Handshake error on mSQL server

    Office 365 Using the Excel PQ or Get & Transform query to retrieve data from SQL but returns the above error message on the other users' computers. My PC doesn't get the error and the queries return the data. Searched online but nothing really helpful. I have used the Excel query part for a few...
  24. A

    Wage History showing raise amount, date it occurs.

    Thanks p45cal that works great too. I will need to remember to do the sort but it is a simple and fast way to display the information. It will depend on the end user as to how the information is displayed as Pivot or linear format. Thanks to both for a great help. Lee
  25. A

    Wage History showing raise amount, date it occurs.

    Thank you it is working very well and what I needed. Thank you very much Narayank991! Lee
Back
Top