Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    14
    Views
    2,006

    Re: Countif in power bi

    That's a great solution, too. At the test with 960.000 lines, it took about 13 seconds. Almost identical with the first solution from cyborgski, which takes about 12 seconds on my computer. Only the...
  2. Replies
    14
    Views
    2,006

    Re: Countif in power bi

    zuriqi last replied on 30 May. But that's how I understood the task.


    But I don't care, because when I help, it's primarily to learn for myself. And I also succeeded very well with this thread
  3. Replies
    14
    Views
    2,006

    Re: Countif in power bi

    Yes, the original order should be retained at the end. Both my and the linked solutions take this into account
  4. Replies
    14
    Views
    2,006

    Re: Countif in power bi

    Hello,


    since my solution produces correct results, but I was not satisfied with the runtime, I asked on excelguru for a better solution and got there two solution variants, which are many faster...
  5. Re: How to delete text between two specific words in cell?

    Same idea as Sandy, but a little bit more.

    Link to my solution in OneDrive
  6. Replies
    29
    Views
    3,173

    Re: Merging UnEven Names in Power Query

    If the Power Query of your Excel version does not yet support the table join with the fuzzy logic, then there is a very simple way.


    Install the free Power BI Desktop version and create the query...
  7. Replies
    29
    Views
    3,173

    Re: Merging UnEven Names in Power Query

    I use 365 and it works. By the way, a few years ago I programmed a fuzzy search myself that also takes synonym lists into account.
  8. Replies
    29
    Views
    3,173

    Re: Merging UnEven Names in Power Query

    Very strange! That should have been called "Table245". But with me the query ran without problems. But now I have reworked it again and added the optional parameter "NumberOfMatches" for the join and...
  9. Replies
    29
    Views
    3,173

    Re: Merging UnEven Names in Power Query

    Hello,


    directly available in the merge of Power BI, but also usable in Power Query of Excel, your problem can be solved very well by using "Table.FuzzyNestedJoin".


    Here is a link to my...
  10. Replies
    5
    Views
    526

    Re: Grouping function in Power BI

    For instance:


    let Source = Excel.CurrentWorkbook(){[Name="Tabelle1"]}[Content],
    Changed_type = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Age", Int64.Type}}),
    ...
  11. Re: Calculate same day of today but last year

    If you like you can take a look into the workbook I'v created

    Link to OneDrive

    or use the PQ M-Code


    let Quelle = Excel.CurrentWorkbook(){[Name="Tabelle1"]}[Content],
    Changed_type =...
  12. Re: Calculate same day of today but last year

    I don't think your idea's fully developed yet. Because Monday the 3rd of June last year was a Sunday. and in leap years you have a 2-day shift of the weekday. It is better to subtract 364 from the...
  13. Re: Power Bi how to meke continuous exceed 4 days (positive), will automatic show total Positive days

    Have now downloaded and installed Power BI. Afterwards created in Power BI a request with idential code of the Excel file. It works without any problems

    have here the Power BI link
  14. Re: Power Bi how to meke continuous exceed 4 days (positive), will automatic show total Positive days

    I used Power Query in Excel. But with only a few exceptions, Power Query should be identical in Excel and Power BI
  15. Replies
    14
    Views
    2,006

    Re: Countif in power bi

    If I use Table.Buffer, the runtime of 11,000 records is reduced to about 50 seconds. This is much better than 7 minutes, but still not good enough



    <colgroup><col></colgroup><tbody>
    let


    ...
  16. Re: Power Bi how to meke continuous exceed 4 days (positive), will automatic show total Positive days

    I have now tested the link from my company laptop and was able to open, download and edit the folder without any problems.


    In another thread sandy666 could probably open my folder, which I had...
  17. Re: Power Bi how to meke continuous exceed 4 days (positive), will automatic show total Positive days

    When re-testing, I noticed that the query did not return correct results in all cases. After the modification of the query, it should be correct now

    Link to my OneDrive file
  18. Re: Power Bi how to meke continuous exceed 4 days (positive), will automatic show total Positive days

    Try that code

    let Source = Excel.CurrentWorkbook(){[Name="Tabelle1"]}[Content],
    Changed_type = Table.Buffer(Table.TransformColumnTypes(Source,{{"Date", type date}})),
    Sorted_lines =...
  19. Re: form from/to areas of single lines works very slow

    The sorting was only a remark, because a wrong sorting influences the group formation.


    Much more interesting is the question of how you knew that the parameter "GroupKind.Local" exists
  20. Re: form from/to areas of single lines works very slow

    Wooooooooooowwwwwwwwwww, this is as fast as I imagined.


    Only by using the additional parameter "GroupKind.Local", which is however not available in the editor of the function "Grouping", is...
  21. Re: form from/to areas of single lines works very slow

    In the query "My code-2" I included the 2nd line in the command "Table.Buffer". This results in a much shorter runtime of about 2 minutes and 30 seconds when I run the query for 8000 lines.


    This...
  22. Re: form from/to areas of single lines works very slow

    Yeah, that looks good!
  23. Re: form from/to areas of single lines works very slow

    Hello sandy666 and citizenbh,


    I have now tested all the codes and seen some interesting solutions. But unfortunately none of them gives the right result. Therefore here is a small example and...
  24. Re: form from/to areas of single lines works very slow

    This new solution looks very good. I will test it with all the lines when I get back home.
  25. Re: form from/to areas of single lines works very slow

    Hi citizenbh,


    this is a very interesting solution, which is also much faster than mine. But when I applied your solution to the entire input (8200 lines), it took almost 15 minutes to get the...
Results 1 to 25 of 31
Page 1 of 2 1 2