Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.10 seconds.

  1. Replies
    3
    Views
    145

    Re: Lookup value from reversed columns and rows

    Here's one way:

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col...
  2. Thread: Vba evaluate

    by Comfy
    Replies
    2
    Views
    49

    Re: Vba evaluate

    Sorry, as often happens I post a question and then continue playing and then possibly find the answer.

    I think it might be due to the string length being used for the address.

    /Comfy
  3. Thread: Vba evaluate

    by Comfy
    Replies
    2
    Views
    49

    Vba evaluate

    Hi Boardies,

    I'm having a little issue with EVALUATE() that I can't figure out.

    I'm testing to see if a selection SUMS to zero and that the same rows in a different column have numbers in them...
  4. Re: Power Query - Returning DateTime type rather than Date

    I had to update the AddNColumns function to the following to get it working properly



    let




    Source = (TableToAddTo as table, ColumnsToAdd as table, optional RowNumber as number) =>
  5. Re: Power Query - Returning DateTime type rather than Date

    Now X-Posted on: https://powerpivotforum.com.au/viewtopic.php?f=5&t=1175
  6. Power Query - Returning DateTime type rather than Date

    Hi Boardies,

    I have written the following functions so that I can add columns to a table recursively using information in a second table:

    Function: AddNColumns


    let
  7. Re: Don't show total until second number entered

    The formula would read:

    =IF(NOT(ISBLANK(B3)),MAX(A3-B3, 0),"")
  8. Replies
    1
    Views
    100

    Re: Compare old and new large price list

    What version of Excel are you using?
    Do you have access to Power Query as this would be very simple to solve?
  9. Re: Don't show total until second number entered

    Here's one way:

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col...
  10. Replies
    3
    Views
    432

    Re: Filter Measure by unrelated table

    If I hard code the filter values I get the required result:

    =CALCULATE([TotalNetSales], FILTER('FACT', 'FACT'[Summary] = "ProductA" || 'FACT'[Summary] = "ProductB" || 'FACT'[Summary] = "ProductC"...
  11. Replies
    3
    Views
    432

    Re: Filter Measure by unrelated table

    I tried that but may have/probably made a mistake as it did not give the result that I was expecting.

    My end goal is to have 6+ dimension tables that filter 6+ measures.

    If I add a relation...
  12. Replies
    3
    Views
    432

    Filter Measure by unrelated table

    Hi Boardies,

    So I've finally got the opportunity to mess around with DAX and some real-world data.

    I have a FACT table.

    DATE | SITE | PRODUCT | NET SALES

    and a Dimension Table that only...
  13. Replies
    1
    Views
    286

    Re: New custom columns confused about type

    That's just default, you can expressly define the data type when adding the column.

    ThisStep = Table.AddColumn(PreviousStep, "New Column", each 0.01, type number)
  14. Re: How to convert this number 18174 to June 23, 2018 in Excel?

    Because dates in excel are actually a count of days since 00/01/1900.

    So to get from 18176 days after this date to 43274 days you can just add 25100
  15. Replies
    5
    Views
    174

    Re: help with a graph

    Reformat your data and use a Pivot Chart.

    Example attached.
    https://filehost.net/3f3307156fdc7139
  16. Re: How to convert this number 18174 to June 23, 2018 in Excel?

    What leads you to believe it's the 23rd of June?

    What date would 18175 be?
  17. Replies
    2
    Views
    329

    Re: Power Pivot losing columns??!

    If I remember correctly and my knowledge may have been superceeded by an update but the PowerPivot addin for 2010 isn't perfect.

    I imagine your Power Pivot connection was created using a PQ Query...
  18. Re: Duplicates error when linking two tables on Power Pivot

    If I read your question correctly I think your problem may be a Many-To-Many relationship in your dates.

    Try creating another table of unique dates.

    And use this to bridge your vendor...
  19. Replies
    2
    Views
    539

    Re: Over coming Many-To-Many

    Hi Eric,

    Thanks for taking the time to respond, I think I found an article that gives me the answer I'm searching for.
    ...
  20. Replies
    2
    Views
    539

    Over coming Many-To-Many

    My Fact table consists of financial transactions.


    <colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>

    A
    B

    </thead><tbody>
    1
  21. Replies
    0
    Views
    109

    Validate Email Sent

    Hi Boardies,

    I have a workbook that sends emails. I'm trying to create a log table to record if any emails weren't sent.

    The problem that I'm encountering is that the code runs too quickly for...
  22. Replies
    0
    Views
    104

    Custom Routine Template File

    I'm in the process of developing a solution using Power Query and/or VBA.

    For the purpose of taking any set of data (from a List Object) and converting this for interface into a financial ledger...
  23. Re: VBA - Mail whole workbook to multiple people seperately

    Either way Ron De Bruin has a very extensive library of solutions for Excel/Outlook/VBA

    https://www.rondebruin.nl/win/s1/outlook/mail.htm

    In particular his Add-in:...
  24. Replies
    3
    Views
    422

    Re: Query Editor - Json formating

    I would use multiple Queries.


    Name: WebQuery24hVolume



    let
    Source = Json.Document(Web.Contents("https://poloniex.com/public?command=return24hVolume")),
    #"Converted to Table" =...
  25. Replies
    7
    Views
    194

    Re: FILTER MULTI BILE columns

    I would suggest converting your table into an Excel Table (ListObject in VBA)
    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4