Search:

Type: Posts; User: Matt Allington; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. Re: Power Query - Remove duplicates from Folder Download

    At a guess.
    1 Add a new Merged column using the 3 columns to make a unique key
    2 branch the query and do a group by the key, distinct count of the file name
    3 filter where count >1. This is a...
  2. Re: Dynamic DAX calculation between two rows of same DAX measure (filtered rows)

    If the June and July cycle are actual sales up until June, why are the numbers different for periods Jan x Jun?
  3. Replies
    1
    Views
    43

    Re: Employee turnover calc

    This is a non trivial task. I suggest you read up on “events in progress” https://blog.gbrueckl.at/2014/12/events-in-progress-for-time-periods-in-dax/. You need to be clear how the % turnover is...
  4. Re: Equivalent of DATESBETWEEN(LASTDATE... ?

    Datesbetween is an inbuilt time intelligence function. To use it, you must
    1. Have a calendar table. https://exceleratorbi.com.au/power-pivot-calendar-tables/
    2. The first parameter must be the...
  5. Replies
    3
    Views
    799

    Re: Is Power Query what I need?

    +1 pq
  6. Replies
    3
    Views
    542

    Re: Eliminate zombie employees

    Yes, this helps. Creating sample data, loading into a model, making sure that the sample data is a suitable set to test etc, is all part of the process of solving a problem. These steps often take...
  7. Replies
    3
    Views
    542

    Re: Eliminate zombie employees

    DAX formulas always depend on the table structure. How about you post a typical sample workbook showing the structure and current formulas.
  8. Re: Which histogram formula is correct?

    The first one is counting the line level items, not the aggregation of all lines in a PO. Have you tried taking the first one, and replace “orders” with “values(orders[PO no.])”
  9. Replies
    1
    Views
    471

    Re: Missing report tabs

    Save, close power BI and reopen again. It is a known bug
  10. Replies
    1
    Views
    566

    Re: Page Navigation

    Search for “drill through filter power BI”.
  11. Replies
    1
    Views
    493

    Re: Count of new customers

    It is all here https://www.daxpatterns.com/new-and-returning-customers/
  12. Re: PowerBI Dataflows (cant see it in the service)

    Probably because you are in “my workspace”. They only exist in App Workspaces.
  13. Re: Power Pivot CALCULATE vs. RELATEDTABLE

    Don’t do any of these. Use measures instead.
    https://exceleratorbi.com.au/calculated-columns-vs-measures-dax/
  14. Re: Members Upload Files to Workspace at powerbi.com?

    I think the process is the same for V1 and V2.
    Click on Workspaces > to expand menu
    find the workspace, click on the ellipsis ...
    Workspace access
    you can add new users or change user access...
  15. Re: Expression Error: The key didn't match any rows in the Table

    The error means you are trying to do something, but it doesn’t exist. Eg it is trying to import a sheet called “sheet1” but there is no “sheet1” to be found in the table. If you are combining files,...
  16. Re: Assign a characteristic to a measure Power Pivot

    In short, no.

    I assume these mean cash flow, profit and loss, balance sheet. If yes, watch this video.
    https://www.youtube.com/watch?v=ojHZkWkEY7Q/
  17. Replies
    4
    Views
    604

    Re: Calculate with rows filter

    It depends on your table structure. If all 3 columns above are in the same table, just drags the ID and Name to rows of the pivot, drags the first column to values, and change he pivot table layout...
  18. Re: Members Upload Files to Workspace at powerbi.com?

    Hi Mike. Are you using the new preview workspace format (v2)? This will be GA in a few weeks. Have you tried adding people as contributors? I think that will fix it.
  19. Replies
    7
    Views
    694

    Re: Doble condition

    then just replace the stock number with the date-time

    SOH =SUMX ( VALUES ( Stock[IdProduct] ),
    CALCULATE (
    SUM ( Stock[Stock] ),
    FILTER ( ALL ( Stock[date-time] ),...
  20. Re: Matrix with DoD (trending data) w/ 7 Day and 14 Day volume change

    This is an asymmetrical matrix which is harder to do. You could probably do it using a disconnected table to pass the measures, similar to this....
  21. Replies
    7
    Views
    694

    Re: Doble condition

    It is nothing to do with Excel. I can't open your Excel workbook (it says it is corrupt), but I could copy it to Power BI. This is what you need to do.
    1. split the date and time into 2 separate...
  22. Re: Import Several csv files into Power Pivot

    Read my article on how to combine csv files with power query
  23. Re: Refreshing Blank Query - Duplicates

    Power Query will load all the data in the source, once and only once. When new data arrives at the source, Power Query deletes all data previously loaded and reloads everything again including the...
  24. Replies
    7
    Views
    694

    Re: Doble condition

    Well you will have to try a few things. The basic pattern is


    LAST Stock =VAR laststock= MAX ( Table[DATE] )
    RETURN
    CALCULATE (
    SUM ( tables[stock]),
    'DATE'[DATE] =...
  25. Re: Power Query - import multiple files from SharePoint

    Have you tried clearing your credentials from Power Query and trying again? They are under data source settings. Also check that you are using the main URL for Sharepoint, not the link to the...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4