Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    145

    Re: Export all sheets as XLSX

    That's exactly what I needed.
    You're the best.
    Thanks.
  2. Replies
    10
    Views
    1,439

    Re: Index Match returning wrong values

    It worked, I got it to work, thanks.
  3. Replies
    10
    Views
    1,439

    Re: Index Match returning wrong values

    I get back if I use the formula like that.
  4. Replies
    10
    Views
    1,439

    Re: Index Match returning wrong values

    I get values from other cells.
    A3 is the lookup value.
    Is the formula correct?
    I have the lookup value in A3, and I am looking for data in the data sheet.
  5. Replies
    10
    Views
    1,439

    Re: Index Match returning wrong values

    View the file and see for yourself, the value returned in the lookup sheet do not match.
    Index Match
    A3, is the lookup value.
  6. Replies
    10
    Views
    1,439

    Index Match returning wrong values

    I have a worksheet with information and I want to grab another piece of information from another sheet.
    In the Data sheet, the names are in a certain order, and I used the index match function to...
  7. Replies
    0
    Views
    78

    Macro to import online xls

    I need a macro to import an online xls, and update only new data added to the table, since I will be making changes to this data manually.
    Can someone please help me make this macro, so I can start...
  8. Replies
    3
    Views
    178

    Re: Create a dynamic chart with dynamic range

    The thing is that when I change the range, I make it so that it shows less information than when the graph was originally created, and the graph doesn't reflect the changes. I change from AM1:AN5 to...
  9. Replies
    3
    Views
    178

    Create a dynamic chart with dynamic range

    I want to create a scattered plot graph with data that will change depending on a selection of a list.
    I already have the dynamic range in a cell, but I can't seem to use the indirect function in...
  10. Replies
    2
    Views
    355

    Re: Cross reference multiple tables

    I want to get all the data I can from all the tables that are linked, the problem is that some tables contain duplicate values and I don't know if this is possible to do with duplicate values, since...
  11. Replies
    2
    Views
    355

    Cross reference multiple tables

    I want to relate multiple table together to a single field, and that way I can use data from multiple tables in a single visualization. Can someone please tell me if this is possible and if so, how?...
  12. How to connect an SQL Database to Power BI

    I wish to know how can I create an sql database to powerbi, to use it as my data source to make further analysis on the data.
    Can someone please help me?
  13. Re: Use match formula and exclude match from next search

    I just tried your answer, but it partially works.
    It ignores the first value, but I need to find the first value and then ignore it and find the second.
    Is this possible?
    Thanks
  14. Use match formula and exclude match from next search

    I want to use a match formula to look for a value in a range of cells, but if there are repeated values, I would like to exclude the first match from the search, that way I don't use the value of the...
  15. Replies
    2
    Views
    465

    Re: Use R functions in Power BI

    Thanks for the reply.
    I tried what was described in the blog, but I need something else, I need to be able to select a column from the query editor, even if its not a csv.


    library(dplyr)...
  16. How to display multiple lines of a single string in a vcard or multirow card`

    I have a long string of text and I want to display the whole thing, without getting the ..., at the end.
    Is this possible, and if so, how?
    Thanks.
  17. Replies
    4
    Views
    1,589

    Re: Cut/Paste values in excel with VBA

    Thanks for responding.
    I used your code and it gives me an a\error saying invalid function.
    Maybe I am not typing it right:


    =cortar(a1,b1)
    //a1 contains data and b1 is where I want to paste
  18. Replies
    4
    Views
    1,589

    Cut/Paste values in excel with VBA

    I am trying to make a function to cut/paste values from a cell I will to specify in function to another cell I wioll also specify in function.
    I tried:


    Function Cortar(a As Rannge, b As Range)...
  19. Replies
    0
    Views
    398

    R visual filter inside Power BI

    I want to filter data inside the R script in the R visual, so I can make and display calculations such as covariance and others based on the years the data was collected.
    I tried this:

    ...
  20. Replies
    0
    Views
    653

    Import Json to Power BI

    I am trying to subset some information imported from a json into power bi.
    I tried the code in RStudio and it worked, but when I imported this code in Power BI, it didn't show any results.
    I...
  21. Replies
    2
    Views
    465

    Use R functions in Power BI

    I was wondering if its possible to use R functions to obtain numeric results in Power BI, with information already imported in Power BI?
    I know that there's an option for R script in Power BI, but...
  22. Replies
    1
    Views
    414

    Concatenate multiple columns

    I need a function or any other method to concatenate multiple function, add "|", and replace " " with "%20", without having to do this 1 by 1.
    If someone could show me how to do this, I would be...
  23. Replies
    0
    Views
    475

    Google sheets formula in Power BI

    I want to use a google sheets formula in power bi, but I am unable to use it, since there is no image function in power bi.
    This is the function I need to use:...
  24. Replies
    1
    Views
    472

    Multiply columns that match in 2 tables

    I have generated an excel sheet in google sheets, that gets the history of currency rate changes from some coins to USD. What I want to do is compare the date of the column in google sheets with a...
  25. Replies
    0
    Views
    457

    Historical exchange rates

    Is there a way to get the historical exchange rates for the dates I have entered in powerbi, so that when there are new dates entered, the exchange rate is automatically placed for that date?
    I need...
Results 1 to 25 of 84
Page 1 of 4 1 2 3 4