Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    21
    Views
    476

    Re: Park Run Data - Scotland

    I'm blocked out again. Looks like I have to wait a few hours, I've tried re-booting without success. I have tried finding the web site's Terms of service, it obviously doesn't like what we are...
  2. Replies
    21
    Views
    476

    Re: Park Run Data - Scotland

    I'll try again later and see if I can work out a way of limiting my calls to their server.
    I didn't realise you just wanted the latest. That makes it a bit easier. I will still try calling up the...
  3. Replies
    21
    Views
    476

    Re: Park Run Data - Scotland

    Unfortunately I get 403 forbidden on the website. However I had a look earlier and would think about the following approach. First create a table of the events you are interested in. Create a...
  4. Re: Calculate Units Picked 17:00 - 04:00am (Shift)

    Darren,
    Unfortunately although I can see your screen shots they make little sense as I cannot see what your input data looks like so I'm guessing what you are trying to achieve.
    Why subtract 17...
  5. Re: Calculate Units Picked 17:00 - 04:00am (Shift)

    I don't really understand your full requirements but how about adding a helper column in the Data Model to subtract 17 hours from the actual date time? Then create a column just containing the shift...
  6. Re: Writing Power Query (M language) Table.X functions that will dynamically tailor the table scope to each row of data

    OK
    Glad you found a solution elsewhere.
  7. Re: Writing Power Query (M language) Table.X functions that will dynamically tailor the table scope to each row of data

    It's not pretty but this is one way of doing it.
    First filter out ignore. Then replace null with zero if that is what you mean to do, otherwise filter out null.
    Then reference this query.
    Then...
  8. Replies
    5
    Views
    719

    Re: Noob question - Excel queries

    I don't really understand your data. However to avoid adding the helper column in the Excel table how about duplicating your query in PQ then grouping by your conditions columns and returning the...
  9. Re: Manually Entered Data Shifting After Refresh

    I'm surprised it doesn't work: speaking from experience with using this technique on a number of applications.
    You need to add the index on the first query after you merge or combine the data from...
  10. Re: Manually Entered Data Shifting After Refresh

    Glad it worked. By the way it is better to use the add index feature in PQ rather than manually create and maintain the column of numbers back in Excel.

    Peter
  11. Re: Manually Entered Data Shifting After Refresh

    Yes it's a brilliant technique to learn. Do a web search for self referencing queries and the answer should be there. Basically you add a unique reference (index) to each row in you original query....
  12. Re: Using Concatenate in DAX in PowerPivot as a Measure

    CONCATENATE only works with two text strings. You need to nest a second CONCATENATE function in the expression =CONCATENATE(Data[Height],CONCATENATE(" x ",Data[Width])). Or just use the & operator...
  13. Replies
    5
    Views
    540

    Re: DAX LOOKUPVALUE with IF/OR included?

    I can't help you with the DAX problem but I am sure it is soluble. I might be wrong be wrong but my way of working with the Power BI concept is to use Power Query (Get and Transform) for ETL...
  14. Replies
    5
    Views
    540

    Re: DAX LOOKUPVALUE with IF/OR included?

    I would be tempted to use Power Query. Load the Lookup Table and the Data table as Queries. Then merge the two, joining on the cost centres (use Ctrl to select the 2nd, 3rd and 4th columns). Expand...
  15. Re: G&T - Get Data from Range without converting it to a Table?

    Another sneaky way on a simple spread sheet is to set your range to the print area (this works well if you are importing from multiple identical spread sheets e.g. if each year/region etc is on...
  16. Re: Using Power Query Connections in Pivot Tables

    Why can't you load the results from the queries into the Data Model? It will easily handle the volume. Then use Power Pivot Tables?
  17. Re: Pulling data from the power query into a spreadsheet not working correctly??!!

    Tony,
    I don't think I completely understand how your data is organised and exactly how your dashboard is meant to look but I will make a couple of suggestions anyway. My first step would be to...
  18. Re: Help Power Query! Marge date fields to create datetime field

    Posted in error
  19. Replies
    5
    Views
    553

    Re: Filtering 2018 to Date

    Try this:
    Table.SelectRows(#"ChangedType", each [date] >= #date(2018, 1, 1) and [date] <= Date.From(DateTime.LocalNow()))

    Peter
  20. Replies
    5
    Views
    553

    Re: Filtering 2018 to Date

    Why is it not appropriate please?
  21. Replies
    5
    Views
    553

    Re: Filtering 2018 to Date

    In Power Query I would take the quick and easy approach of creating a new year column by extracting the year part of the date which is easy to do via the UI. Then filter by that column.
  22. Replies
    2
    Views
    470

    Re: Excel formula to Power BI DAX

    Unless someone is smarter than me would me it help if if you provided sample data with expected result.
  23. Thread: DAX Formula?

    by peter789
    Replies
    2
    Views
    362

    Re: DAX Formula?

    Why do you want to use DAX? Easy to accomplish in Power Query. Group the timesheet table by Project, Task and Sub-Task. Sum the budget hours. Merge the project table with the summarised timesheet...
  24. Re: Data set comparison... what's the best method?

    Thanks Matty,
    That's what I had been trying but when it didn't work I was struggling; main problem was that connecting two to one doesn't deactivate the second relationship. I think you've nailed...
  25. Re: Data set comparison... what's the best method?

    I'm trying to learn from this useful tip but can't make it work. I guess the first problem I have is trying to load the same table twice , any suggestions?

    Peter
Results 1 to 25 of 87
Page 1 of 4 1 2 3 4