Forum Replies Created
June 6, 2018 at 9:33 pm in reply to: #10001
trying to upload file.
Attachments:You must be logged in to view attached files.
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! 🙂May 12, 2016 at 8:48 pm in reply to: Development Factor Applied To Rolling Current Month #4604
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.
MikeMay 11, 2016 at 3:48 pm in reply to: Development Factor Applied To Rolling Current Month #4586
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.
MikeMay 11, 2016 at 2:59 am in reply to: Development Factor Applied To Rolling Current Month #4566
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.
MikeMay 10, 2016 at 2:55 pm in reply to: Development Factor Applied To Rolling Current Month #4555
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.
MikeMarch 7, 2016 at 4:14 pm in reply to: Printing a list of Measures (or calculated fields) with Formulas #3631