Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Thread: Month Name

    by ralliartur
    Replies
    5
    Views
    804

    Re: Month Name

    This is not the case - OP made a mistake using numbers for month 1..12 and then used Format to get month name which is wrong, as excel needs full date to get month name in the right way. If you want...
  2. Re: DAX Measure Optimization for Multiple Tables

    Basing on your measure I would propose:



    Controlled PO no Pharmacy :=
    SUMX (
    FILTER (
    CALCULATETABLE (
    Vouchers,
    Vouchers[Post Status] = "Posted",
  3. Re: Splitting a CSV with Powershell as a Post command in Informatica Cloud

    Hi, For the first one:

    1. missing delimiter in Import-Csv
    2. Missing quotes in Import-Csv (this is optional - i had spaces in my path)
    3. Space between "- Path" in Export-Csv
    4. Missing quotes...
  4. Replies
    2
    Views
    964

    Re: DAX formula - Cumulative Count

    First: this will work only in calculated column
    Second: it requires index column



    =CALCULATE (
    COUNTROWS ( CityList ),
    FILTER (
    CityList,
    CityList[CityName]
  5. Replies
    5
    Views
    1,132

    Re: Count Values Greater Than Measure Average

    You are right this is conversion from true/false to numeric 1/0 in order to get sum

    The hidden reason - i don't like IF in DAX statements
  6. Re: Split Column on first numeric character

    You can add this function by creating a new blank query, then go to advanced editor and paste my code -it will not ask for parameters.
  7. Replies
    5
    Views
    1,132

    Re: Count Values Greater Than Measure Average

    Sorry, VARS are not in Excel2013 Either

    in this case Above MEDIAN:=SUMX(Tabela1; (Tabela1[Average]>CALCULATE([MEDIAN];ALLEXCEPT(Tabela1;Tabela1[Category];Tabela1[Subcategory])))*1)
  8. Re: Split Column on first numeric character

    Simple function can help:


    let
    Source = (string as text) => let
    Source = {0,1,2,3,4,5,6,7,8,9},
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(),...
  9. Replies
    5
    Views
    1,132

    Re: Count Values Greater Than Measure Average

    Hi,

    Yes it can be done in measure, and i have one suggestion:

    1. You can use standard MEDIAN() DAX formula
    MEDIAN_NEW:=MEDIAN(Tabela1[Average])

    2. Now the calculation looks like this: ...
  10. Replies
    2
    Views
    595

    Re: Drill down Rows

    I don't know if i've understood correctly the request, but i can propose this:

    My table:


    <tbody>
    aaa


    Header
  11. Replies
    1
    Views
    4,586

    Re: Power Query - Reformat a number to text

    The function you are looking for is Text.PadStart

    "REF" & Text.PadStart(Number.ToText([field]), 5, "0")
  12. Re: Import multiple tables at once via SQL statement ... ?

    Ok, last chance for me to convince you to try pq for data source with multiple tables:

    You are using excel 2013, so power query is not installed by default, but you can do it on you own. Give...
  13. Re: Import multiple tables at once via SQL statement ... ?

    It depends - building separate connections to import tables in power pivot is time consuming too. In power query you are choosing connection once and all tables in the same step. Them obviously you...
  14. Re: Import multiple tables at once via SQL statement ... ?

    That's why i suggested first using power query to connect to db, choose tables, choose columns and load data into power pivot model. I've tried some queries in connection manager but none of them...
  15. Re: Import multiple tables at once via SQL statement ... ?

    Use Power Query to connect to sql, choose tables and transform data. Then load the data directly to power pivot model.

    Edit:
    Your sql statement is only limited to choose columns, so you can use...
  16. Replies
    3
    Views
    20,231

    Re: Max value in list - Power Query

    Thanks,

    I've learned from books and blogs (and my own work):

    Books:
    1. Power Query for Power BI and Excel
    2. M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query

    Blogs:...
  17. Replies
    3
    Views
    20,231

    Re: Max value in list - Power Query

    You are looking for this solution:

    AddCustom = Table.AddColumn(ChangedType, "Custom", each List.Max(ChangedType[a]))

    Explanation:
    ChangedType - name of previous step in your query
    [a] - name...
  18. Replies
    1
    Views
    3,451

    Re: Duplicates after Power Query Left Join

    You are using column (in join) which is not distinct in one of the tables. This is the only reason.
  19. Replies
    2
    Views
    429

    Re: How make multiplication table 10x10

    Quite interesting task - i have solution without using source table, only by using List.Generate



    let
    Source = List.Generate(()=> 10, each _ < 110, each _ + 1),
    ToTable =...
  20. Replies
    1
    Views
    474

    Re: Power Query data problem

    Hi,

    It seems that you have problems with encoding declaration for this files - you should have parameter like that at the end -> "Encoding=1250" (the number should be the same as for individual...
  21. Replies
    5
    Views
    457

    Re: Unpivot date data

    I was suggesting to use default action - keep in mind that it is not always obvious to use dropdown list in ribbon menu.
  22. Replies
    5
    Views
    457

    Re: Unpivot date data

    1. Select columns with day number and then select unpivot (not as suggested above!)
    2. Change "Attribute" to Data Type Whole Number
    3. Add custom column with Formula...
  23. Replies
    55
    Views
    8,193

    Re: Power Query and SharePoint

    There are more options to do it.

    1. Open sharepoint site, go to Library -> open with explorer
    2. Windows Explorer window will open -> copy full address from navigation bar (it should be like...
  24. Re: What should be my Date range in the dCalendar table?

    In Excel 2010 use Power Query to transform the data and choose connection only as Load method, then go to Power Pivot window and choose Design tab -> Existing connections -> workbook connections
  25. Replies
    5
    Views
    925

    Re: VBA Save As not working.....

    What do you have under the "dte" variable?
Results 1 to 25 of 29
Page 1 of 2 1 2