# Search:

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

Page 1 of 6 1

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

by mgirvin
Replies
44
Views
1,345

### 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. ## Thread: How to extract multiple values (exc duplicates) with two criteria

by mgirvin
Replies
44
Views
1,345

### 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. ## Thread: How to extract multiple values (exc duplicates) with two criteria

by mgirvin
Replies
44
Views
1,345

### 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. ## Thread: How to extract multiple values (exc duplicates) with two criteria

by mgirvin
Replies
44
Views
1,345

### 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. ## Thread: How to extract multiple values (exc duplicates) with two criteria

by mgirvin
Replies
44
Views
1,345

### 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. ## Thread: How to extract multiple values (exc duplicates) with two criteria

by mgirvin
Replies
44
Views
1,345

### 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. ## Thread: How to extract multiple values (exc duplicates) with two criteria

by mgirvin
Replies
44
Views
1,345

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

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

by mgirvin
Replies
44
Views
1,345

### 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. ## Thread: How to extract multiple values (exc duplicates) with two criteria

by mgirvin
Replies
44
Views
1,345

### 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. ## Thread: How to extract multiple values (exc duplicates) with two criteria

by mgirvin
Replies
44
Views
1,345

### 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. ## Thread: Expanded Table for Many To Many Relationship?

by mgirvin
Replies
4
Views
751

### 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. ## Thread: Expanded Table for Many To Many Relationship?

by mgirvin
Replies
4
Views
751

### Re: Expanded Table for Many To Many Relationship?

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

by mgirvin
Replies
4
Views
751

### 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. ## Thread: Expanded Table for Many To Many Relationship?

by mgirvin
Replies
4
Views
751

### 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:...

by mgirvin
Replies
5
Views
1,219

### 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

by mgirvin
Replies
4
Views
257

### Re: Members Upload Files to Workspace at powerbi.com?

Thanks, Matt!

by mgirvin
Replies
4
Views
257

### 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?

by mgirvin
Replies
4
Views
257

### 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. ## Thread: Change From Previous

by mgirvin
Replies
2
Views
582

### 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. ## Thread: Change From Previous

by mgirvin
Replies
2
Views
582

### 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. ## Thread: Months and Days Between Dates

by mgirvin
Replies
9
Views
339

### 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. ## Thread: Months and Days Between Dates

by mgirvin
Replies
9
Views
339

### 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. ## Thread: Months and Days Between Dates

by mgirvin
Replies
9
Views
339

### 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. ## Thread: Months and Days Between Dates

by mgirvin
Replies
9
Views
339

### 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:
...

by mgirvin
Replies
5
Views
1,219

### 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