Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. What is the Substitute for COUNTIFS date based formula ?

    So I have this formula in excel in my raw data

    =COUNTIFS([Date range],">="&(EOMONTH(Date,-1)+1),[Date range],"<="&EOMONTH(Date,0))

    Power BI however doesn't have this function. I tried to use...
  2. Is it possible to avoid refreshing of present data in Excel Query ?

    I am trying to figure out how to continuously pull data from multiple excel files, but not allow excel/query to change manually edited values back to source values
    Example:
    I have June, July,...
  3. Re: Is it possible to teach Power BI a Text mining/analysis without using any platforms.

    Thanks for reply
    I know I can, but I am wondering if I can do that specifically for this task ? So far I didn't find any good material on how to do it.
  4. Is it possible to teach Power BI a Text mining/analysis without using any platforms.

    So far throughout my searches I always end up being offered MS Cognitive or Azure.
    Is it possible to somehow teach Power BI to recognize phrases with Python/R (or any other accessible tool) or build...
  5. Re: Is it possible to create a VBA code that would recognize phrases out of context ?

    Yeah, I was suspecting something like that, but still decided to try my luck
    Thank you for letting me know though.
  6. Is it possible to create a VBA code that would recognize phrases out of context ?

    So far I know how to extract certain words and potentially even match it into phrases without using VBA, but it is very crippled.
    But is it possible to teach/have VBA recognize the phrases out of...
  7. Re: Lookup value from reversed columns and rows

    Is it possible to create formula that would sum values by several dates for each location and assigned in the same case ?
  8. Re: Lookup value from reversed columns and rows

    Thank you a lot.
    That's what I have been looking for.
  9. Lookup value from reversed columns and rows

    Source table

    <colgroup><col><col span="5"><col></colgroup><tbody>

    tine 2
    tine 2
    tine 2
    Hitte 3
    Hitte 3
    Hitte 3
  10. Re: Do until loop doesn't work with complex reference formula ?

    Yep, I tried it exactly the way it is. While it did change one experiment formula, it didn't work with mine.
    However, I indeed had Fixed chosen. Once I got rid of it, it did work.
    Thank you a lot....
  11. Re: Do until loop doesn't work with complex reference formula ?

    Thank you response. It doesn't seem to work. I tried both code and text to columns button.
    Tbh, I am not well aware of text to columns, so maybe I am doing something wrong, but all it does is...
  12. Do until loop doesn't work with complex reference formula ?

    So generally I am trying to make my text formula work, but as many other methods, this one doesn't work for some reason.

    =IFERROR('K:\PLANING\Apr\[Thu, Apr 11.xlsb]Millright...
  13. Re: How to cell reference from certain files based on dates

    For some reason I cannot see uploaded picture. So just in case describing it here: It is Update Values popup window. It wants me to select the file (I press cancel obviously)
  14. How to cell reference from certain files based on dates

    I have daily files that "feed" information to summary file. Right now it is a manual process. (copy-paste)
    There are certain cell ranges in daily file that feed information to specific sheet and...
  15. How to make/create OR operator between fields in Power BI ?

    So I have 2 fields
    Problem
    Work Performed

    Both can contain similar information, thus both can contain specific info.
    So far apps provide only AND operator. If I create filter for Problem and...
  16. Replace texted reference formula with real one with non existing files

    So I have a reference formulas created by Concatenate formula. which is spread on 3500+ cells

    Here is concatenate formula
    CONCATENATE("=","IFERROR","(",CONCATENATE("'",$B$2,"...
  17. Re: Make dynamic advanced filter trigger on formula value update

    yep, got it :)
    thank you !
  18. Re: Make dynamic advanced filter trigger on formula value update

    Thank you a lot. Looks like it is working.
    So generally speaking, when I add new range in
    If Not Intersect I can use this range as both value and formula for other ranges in Intersect ?
  19. Re: Make dynamic advanced filter trigger on formula value update

    So far I am planning to reference cells in the same sheet.
    And formula will be only in E5 and F5 cells, other cells will still be change on value.
  20. Re: Make dynamic advanced filter trigger on formula value update

    I want E5 to have the following formula
    =Concatenate("*",P2,"*")
    Where E5 is a part of filter and P2 is just a cell in the same sheet.
    (this will allow to search based on keyword and apply...
  21. Re: Formula is pulling data from deleted file ? [or #REF error not showing up]

    Thank you,
    Weird behavior, didn't expect Excel to work this way.
  22. Re: Make dynamic advanced filter trigger on formula value update

    Hey, thank you for helping.
    Is it possible to discuss it without uploading the file ? From what I read dropbox service has a weird policy, which I do not support.
    Formula is very simplistic, it...
  23. Formula is pulling data from deleted file ? [or #REF error not showing up]

    So yeah I used basic cell reference to other workbook, then I deleted this workbook, but numbers stayed ?
    When I try renter this formula, all it asks me is to find file path, once I cancel it just...
  24. Re: Make dynamic advanced filter trigger on formula value update

    Thank you for clarifying this.
    I am trying to figure out how to apply 1st method, as the 2nd one doesn't work, because I need to use value change as well.

    https://ibb.co/HCy7dB2
    So far the way...
  25. Make dynamic advanced filter trigger on formula value update

    So currently I have an advanced filter that triggers on value input. However when I try to make criteria cell formula based it ignores changes. unless I click on cell and hit enter
    Here is my...
Results 1 to 25 of 42
Page 1 of 2 1 2