Search:

Type: Posts; User: Craigc3814; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    568

    Re: Power Query - Changing Source

    You have to change the source on every single query that is connected to your old source. The first reply to your post explains it in great detail but all you have to do is look at all of your...
  2. Replies
    0
    Views
    328

    Power BI Return Max Date

    I have rummaged through posts but cannot get any formulas to work

    I have a project table that has Project ID's (only one occurrence of each ID)

    then I have a schedule table that has the same...
  3. Replies
    0
    Views
    368

    Power Pivot Date Join

    I have 3 tables,

    One is a workorder table that has the due date of some 300 workorders (obviously dates are repeated)

    Second table is a supervisor table for dates that supervisors worked (again...
  4. Replies
    0
    Views
    321

    DAX formula or PowerPivot connection?

    I have two tables one that shows all of my work order data and a column called due dates that a user manually updates to assign due dates to a given work order.

    I have another table called...
  5. Replies
    0
    Views
    311

    Assigning work to people by day

    Good afternoon, I download a spreadsheet once a month that contains workorders for a given department. The workorders are divided up by responsibility and by the activity code. We then assign the...
  6. Re: Assigning X amount of assignments per day

    Thread if no longer needed, please delete
  7. Assigning X amount of assignments per day

    Once a month I download a list of workorders for my company and assign X amount of work orders to each group per day (table below). Another table is the list of each and every work order we have. I...
  8. Re: Combining files from folder deletes column data of 2nd file

    Solved
  9. Re: Combining files from folder deletes column data of 2nd file

    Column header had 1 character difference and it was ruining everything, got it figured out. Do not know how to delete the thread
  10. Combining files from folder deletes column data of 2nd file

    I have never seen this before. I have 2 files in a network folder and they both show available fund remaining for every project that my company has. One is from February, and I formatted it about a...
  11. Replies
    2
    Views
    505

    Re: Prevent merging query multiple times

    Here are some example from the data tab


    <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
    Budget ID
    Project Name
    Project Manager
    Division/Department
    Spending Geometry...
  12. Replies
    2
    Views
    505

    Re: Prevent merging query multiple times

    Here is the spending curve table


    <colgroup><col><col><col><col></colgroup><tbody>
    Percentage Complete
    Trapezoid Current
    Back Loaded Current
    Front Loaded Current
  13. Replies
    2
    Views
    505

    Prevent merging query multiple times

    The current code that I have is FUNCTIONAL (thanks in large part to help from here I apologize for forgetting your @ as you were a tremendous help). What I would like to do is speed up the code that...
  14. Replies
    18
    Views
    1,167

    Re: Running Total Distinct Count

    I apologize, if I put the project names in and somehow a contractor got a hold of the data and was able to review upcoming projects prior to everyone else learning of them I would get DESTROYED. This...
  15. Replies
    18
    Views
    1,167

    Re: Running Total Distinct Count

    Here is my current code (minus what you added). Clearly I am doing more than what I shared with you and I am sure that is where the issue lies.

    I basically start with an input table for people...
  16. Replies
    18
    Views
    1,167

    Re: Running Total Distinct Count

    Just ran out to lunch then have a meeting. I cannot post the actual data as it is government projects. I can post the code as soon as I get back this afternoon. Adding mockup data would be easy as...
  17. Replies
    18
    Views
    1,167

    Re: Running Total Distinct Count

    Not sure what I am doing wrong, I copied and pasted your formula (changed project to project name as it is called in my table) in but when it groups it is washing out the multiple amount of times...
  18. Replies
    18
    Views
    1,167

    Re: Running Total Distinct Count

    So I need to create a custom function for this portion correct

    let
    Source = Excel.CurrentWorkbook(){[Name="tblProjects"]}[Content],
    countColumnAdd = Table.AddColumn(Source, "Instance",...
  19. Replies
    18
    Views
    1,167

    Re: Running Total Distinct Count

    I do not understand how it would work. The solution from Marcel sums a number column (cost). I do not want to sum anything nor do I have anything to sum. All I want to do is count rows, if I group...
  20. Replies
    18
    Views
    1,167

    Re: Running Total Distinct Count

    I am not using numbers unfortunately, I am trying to count the occurrences of text.
  21. Replies
    18
    Views
    1,167

    Running Total Distinct Count

    I have a table I am working with that has project names that are listed multiple times (along with a bunch of other data that should not be relevant here). This is in Power Query

    What I want to do...
  22. Replies
    2
    Views
    428

    Re: DAX Formula?

    Yea, it was a completely dumb question. I am pretty new to Power BI but would rank myself as high intermediate in PQ (I can figure out anything in PQ so far just probably not always in the most...
  23. Replies
    2
    Views
    428

    DAX Formula?

    I have two table one is my project table and it contains all information regarding any projects that we have. I also have a Timesheet table that gives me all employees timesheet data.

    Both tables...
  24. Replies
    1
    Views
    332

    Re: Grand total column Power BI

    I figured it out, I needed to do a DAX calculation rather than a new column in editor. How do I delete this post?
  25. Replies
    1
    Views
    332

    Grand total column Power BI

    I have two columns in my Power BI table, one for Project Fee this is the total Fee my company will be charging for a project it was already loaded to the table when I brought it in. Then I created a...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4