Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. 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...
  2. Re: Expanded Table for Many To Many Relationship?

    Anyone? Any ideas?
  3. 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:
    ...
  4. 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:...
  5. 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
  6. Re: Members Upload Files to Workspace at powerbi.com?

    Thanks, Matt!
  7. 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?
  8. 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...
  9. Replies
    2
    Views
    482

    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.
  10. Replies
    2
    Views
    482

    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...
  11. Replies
    9
    Views
    291

    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:...
  12. Replies
    9
    Views
    291

    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.
  13. Replies
    9
    Views
    291

    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...
  14. Replies
    9
    Views
    291

    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:
    ...
  15. 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...
  16. DAX Calculated Column, Multiplying Order Changes Answer?

    Dear Team,

    I have a table in the Power Pivot Data Model. I have created two Calculated Columns that are supposed to calculate the Line Item COGS for each sale. The two Formulas are identical,...
  17. Re: DAX Iterator Efficiency: Formula or Measure in Second Argument of AVERAGEX?

    I did not try VALUES because there were no duplicate prices. I will have to try a data set with duplicate prices soon, to see how to goes.

    Thanks again, Matt Allington : )
  18. Re: DAX Iterator Efficiency: Formula or Measure in Second Argument of AVERAGEX?

    Dear Matt Allington,

    Thank you very much for the hot tips! I just have never dealt with more than 10 million rows of data and so I had not thought to iterate over the product table like you...
  19. Re: DAX Iterator Efficiency: Formula or Measure in Second Argument of AVERAGEX?

    Thanks Matty!
  20. Re: DAX Iterator Efficiency: Formula or Measure in Second Argument of AVERAGEX?

    Okay, I guess I answered my own question. In the first post I was comparing Measure [2] and [3] using a 3000 row table. I just tried the comparison on a 2 million row table, and the DAX Studio...
  21. DAX Iterator Efficiency: Formula or Measure in Second Argument of AVERAGEX?

    Note: I recently posted my DAX Formula question at the Microsoft Power BI Forums (https://community.powerbi.com/t5/Forums/ct-p/Forums) and had a really bad experience (my post was marked as spam and...
  22. Re: Power Query From Table Range button grayed out after Aug update

    Dear sandy666,

    I am not exactly sure what your succinct communication means, but the Excel Tables are not protected and the cell is not in edit mode, so that is not the issue. I hope I interpreted...
  23. Power Query From Table Range button grayed out after Aug update

    Power Query From Table Range button greyed out after Aug update

    Dear Team,

    On both my home computer and now my work computer, after I updated my computer, if I have a cell selected in an Excel...
  24. Replies
    3
    Views
    548

    Re: Lookup nth item in a column

    Thank you both, bkjohn2016 and macfuller!!

    I eventually had to abandon "relative position" and just use Exact Match and LOOKUPVALUE. I converted the approximate match lookup value to an exact...
  25. Replies
    3
    Views
    548

    Lookup nth item in a column

    Dear Team,

    In Excel we can lookup a value using INDEX and MATCH function, where the MATCH function returns the row number or relative position of an item in a list. How do we do this is DAX?...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4