Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • in reply to: #10001

    mikechina
    Participant
    • Started: 0
    • Replies: 7
    • Total: 7

    trying to upload file.

    Attachments:
    You must be logged in to view attached files.
    in reply to: Adding a measure after values column #4934

    mikechina
    Participant
    • Started: 0
    • Replies: 7
    • Total: 7

    You may also be able to get at what your looking for by using the topn function in a measure.  Sorry, on the road, so can’t open the excel docs to give you the exact formula, but in my head it should work.  If not, just disregard! 🙂

    in reply to: Development Factor Applied To Rolling Current Month #4604

    mikechina
    Participant
    • Started: 0
    • Replies: 7
    • Total: 7

    TOM!

    I was thinking the same thing!  I also have a slightly different thing to add to the idea, but I think I’ll email you privately.  Is your email public?  If not, are you able to see my email from logging in to this site?  If you can, can you shoot me an email.

    Thanks,

    Mike

    in reply to: Development Factor Applied To Rolling Current Month #4586

    mikechina
    Participant
    • Started: 0
    • Replies: 7
    • Total: 7

    Thanks Tom,

    Do you ever have a user input data in an excel table to use as a parameter in PowerQuery?  I’m trying to figure out the equivalent in PowerBi desktop.  Not sure if the new parameter feature would work in PowerBI desktop because I would like the end user to pick the parameter, not the developer, if that makes sense.

    Thanks,

    Mike

     

    in reply to: Development Factor Applied To Rolling Current Month #4566

    mikechina
    Participant
    • Started: 0
    • Replies: 7
    • Total: 7

    Hey Tom, quick question.  Do you use PowerBi a lot?  If so, do you find that you can do everything you can do in Powerquery in excel, you can also do in PowerBi?  Are you the moderator of the PowerBi forum?

    Hopefuly Carl won’t be mad that I hijacked his thread.  However, it may actually turn out to be relevant for him.

    Thanks,

    Mike

    in reply to: Development Factor Applied To Rolling Current Month #4555

    mikechina
    Participant
    • Started: 0
    • Replies: 7
    • Total: 7

    Tom,

    I used to work with this guy so stop doing his work!!!! 🙂

    Also, this may already be built out for him, he’ll just have to open up a lot of files on the network to find it!

    My suggestion would be to have a disconnected table with group code, month offset, and factor going vertically not horizontally.  Make a harvester measure to get factor and then use switch true to fetch the factor.  I used the difference between NOW() and report date to filter on Month offset, but if you don’t like NOW(), you can take max report date vs report date.  I don’t want to type it all out because I think it’s more fun to figure it out, plus the book is sitting right to the left of him!  This can all be done in PowerPivot.

    I also like the way you did it to Tom!  Thanks for sharing.

    Mike

     

     


    mikechina
    Participant
    • Started: 0
    • Replies: 7
    • Total: 7

    This is also amazing:

    http://daxstudio.codeplex.com/

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