Home Forums Power Pivot Last Location Worked

Tagged: ,

This topic contains 5 replies, has 2 voices, and was last updated by  sjhc1177 1 week, 2 days ago.

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #18119

    sjhc1177
    Participant
    • Started: 20
    • Replies: 22
    • Total: 42

    H, I have data in power query and then loaded in power pivot.

    I would like to know the last location you worked at.

    So each employee has a line with their pay amount, location, date…

    They can move from location to location so I need to know MAX “Start of Pay” and then the location from that pay period.

     

    This gives me LAST DAY WORKED. I just need to now know the location.

    LAST DATE WORKED:=CALCULATE(MAX(RISEPayrollHistoryCombined[Start Of Pay Period]))

    Attachments:
    You must be logged in to view attached files.
    #18121

    brawnystaff
    Participant
    • Started: 8
    • Replies: 22
    • Total: 30

    See below

    Attachments:
    You must be logged in to view attached files.
    #18123

    sjhc1177
    Participant
    • Started: 20
    • Replies: 22
    • Total: 42

    Thanks, I think that did it.

     

    I did try every way I could think of, was close but just couldn’t finish.

    #18124

    sjhc1177
    Participant
    • Started: 20
    • Replies: 22
    • Total: 42

    Hi, thanks for your help.

    Last question I have is now I want to be able to subtotal by department. But since it’s a measure I can’t and can’t create a slicer from it either.

     

    What are your thoughts?

    #18125

    brawnystaff
    Participant
    • Started: 8
    • Replies: 22
    • Total: 30

    Would need to created a Calculated Column for use in a slicer.

    See attached revision..

     

     

    Attachments:
    You must be logged in to view attached files.
    #18127

    sjhc1177
    Participant
    • Started: 20
    • Replies: 22
    • Total: 42

    Wow, that is great. Thank you so much.

    I can see the application of using that in other areas.

    You have helped me a ton.

     

    Cheers

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.