Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. Re: How to extract multiple values (exc duplicates) with two criteria

    danhendo888,

    If you want to learn, that class is there for you : )

    No worries about the formulas, because you had awesome MVP Marcelo Branco to walk you through a solution : )
  2. Re: How to extract multiple values (exc duplicates) with two criteria

    danhendo88, for text maybe these:

    Formula in cell B16: =SUM(--(FREQUENCY(MATCH($B$5:$B$11&$C$5:$C$11,$B$5:$B$11&$C$5:$C$11,0),ROW($B$5:$B$11)-ROW($B$4))>0))

    Formula in cell B19:...
  3. Re: How to extract multiple values (exc duplicates) with two criteria

    Those video are not just light weekend reading : ( Video #9 alone would take the whole weekend, as it is about a lot of the nuts and bolts of M Code. For # 9 video, I think the pdf notes are 40...
  4. Re: How to extract multiple values (exc duplicates) with two criteria

    danhendo888, I have full free Power Query Classes at YouTube. From Basics to hard core M Code. The MSPTDA class I teach is advanced, but if you study videos #3 - 12, it is most of what you need to...
  5. Re: How to extract multiple values (exc duplicates) with two criteria

    That is funny: tomorrows video shows how to do this with Power Query.

    Important note: Microsoft says it is only in Office 365. There are other things besides Dynamic Arrays and the new Excel...
  6. Re: How to extract multiple values (exc duplicates) with two criteria

    If you have Office 365 Insider Edition, there is a MUCH easier solution. Here it is:

    Data in K1:M9:

    Vendor Invoice Reference
    1000010034 2216705 8190052331
    1000010034 2216705 8190052331
    ...
  7. Re: How to extract multiple values (exc duplicates) with two criteria

    Opps. The correct formula for N26, should be:...
  8. Re: How to extract multiple values (exc duplicates) with two criteria

    Sorry, I do not have the nice solution formatter that you had in your post.
  9. Re: How to extract multiple values (exc duplicates) with two criteria

    Maybe something like this:

    Data in K1:M9:

    Vendor Invoice Reference
    1000010034 2216705 8190052331
    1000010034 2216705 8190052331
    1000010034 2216705 8190000001
    1000010034 2216705 8190000001...
  10. Re: How to extract multiple values (exc duplicates) with two criteria

    I will think about a solution. In the meantime, check out this video of potential ideas that should work: https://www.youtube.com/watch?v=_8dgNqkV1f8
  11. Re: Expanded Table for Many To Many Relationship?

    Matty,

    That is exactly what I did. The Bridge Table in the picture is the result of using Power Query to build Bridge Table and then build the relationships. My question is, do the columns from...
  12. Re: Expanded Table for Many To Many Relationship?

    Anyone? Any ideas?
  13. Re: Expanded Table for Many To Many Relationship?

    When I do a test to see if the columns from the dAuthor and BridgeAuthorBooks (Bridge Table) are present in the fSales Expanded Table, I created the measure:

    =COUNTROWS(fSales)

    then when I:
    ...
  14. Expanded Table for Many To Many Relationship?

    Dear Team,

    I have a Data Model that contains a Many To Many Relationship and a Bridge Table. Here is the picture of my Data Model:...
  15. Re: DAX Calculated Column, Multiplying Order Changes Answer?

    Owen,

    I just have to say thank you again for helping me with this!

    Sincerely, Michael Girvin
  16. Re: Members Upload Files to Workspace at powerbi.com?

    Thanks, Matt!
  17. Re: Members Upload Files to Workspace at powerbi.com?

    Thanks for replying Matt!!! I do not think that I am using the new preview. How do I add people as contributors?
  18. Members Upload Files to Workspace at powerbi.com?

    Dear Team,

    I have created a Workspace at powerbi.com and added members by e-mail. But when one of the members tries to upload, they cannot see the Workspace. I would like all the members that I...
  19. Replies
    2
    Views
    535

    Re: Change From Previous

    Thank you, theBardd. That is straight forward and clever : ) That does work for the pattern shown in the data set, but stock price dates do not always follow that pattern.
  20. Replies
    2
    Views
    535

    Change From Previous

    Dear Team,

    I have a table of dates and GE Stock Prices. I would like a Calculated Column that calculates the change in stock value day by day. THE DAX I have created is this:

    Calculated Column...
  21. Replies
    9
    Views
    310

    Re: Months and Days Between Dates

    Shg, I got same result with iDate as with:

    a formula like this: =DATEDIF(A2,B2,"m")&" months & "&B2-EDATE(A2,C2)&" days" yields this: 11 months & 1 days
    a formula like this:...
  22. Replies
    9
    Views
    310

    Re: Months and Days Between Dates

    Thanks, shg. Thanks for the VBA and assumptions. I am looking for a formula, but perhaps I can try your assumptions.
  23. Replies
    9
    Views
    310

    Re: Months and Days Between Dates

    Thanks for the post, navic. That was not quite what I was looking for. The formula still yields negative days in certain situations. Unless... What are your assumptions that makes negative days...
  24. Replies
    9
    Views
    310

    Months and Days Between Dates

    Dear Team,

    I do not accurately know how to calculate months and days between two dates. I am not even sure what sort of assumptions that I should make.

    If I have these dates:
    ...
  25. Re: DAX Calculated Column, Multiplying Order Changes Answer?

    Dear Owen,

    Brilliant, Owen : )

    Thank you very much for unearthing the issue here.

    However, the implication seems disturbing. It seems to me that in order to not disrupt all of mathematical...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4