Search:

Type: Posts; User: VBA Geek; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.10 seconds.

  1. Re: Convert 2nd column values to rows when column 1 is the same name

    yes, but this depends on your data source. pandas supports various data sources you can build a dataframe from
  2. Re: Convert 2nd column values to rows when column 1 is the same name

    In Python you can do it like this using pandas




    import pandas as pd


    data = {'Street': ['10th street'] * 3 + ['11th street'] * 2,
    'task': ['Repair Pothole', 'New Stop Sign', 'New...
  3. Re: Calculate expenses of previous month issues

    Hi Cyril

    you may want to first build a date table: http://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns

    and then check out DAX time intelligence functions,...
  4. Replies
    1
    Views
    424

    Re: VAR inside CALCULATE?

    Hi macfuller,



    yes CompleteDate is calculate for each row
  5. Replies
    1
    Views
    614

    Re: MINIFS in Power BI DAX

    Hi Shales

    it is possible, can you post a visual example of what you're trying to achieve?
  6. Replies
    5
    Views
    1,125

    Re: Combining Hundreds of tables

    Power Query can handle this no problem but it may take a while to refresh the data, importing from excel is not as far as when importing from a database. Give it a shot and see how long it takes, i'd...
  7. Replies
    1
    Views
    471

    Re: Filter - now Date but I want Year

    You can create an additional table containing just the years found in the fact table:

    =<br><span class="Keyword" style="color:#0070FF">SUMMARIZE</span><span class="Parenthesis"...
  8. Re: Calculate percentage absenteeism in power bi

    I can see the file now. How would you calculate the % of absenteeism? Time Off (PAR_HOURS) / Hours Paid (Leave Hours) ?
  9. Re: Calculate percentage absenteeism in power bi

    Normally a normal OndeDrive, GoogleDrive, DropBox path should be fine
  10. Re: Calculate percentage absenteeism in power bi

    Hello, I haven't been able to open this file so far
  11. Re: Calculate percentage absenteeism in power bi

    Hello, can you share with us a sample of your dataset??
  12. Re: Calculate the difference in minutes of 2 rows

    Hello, can you share with us a sample of your dataset??
  13. Re: Using data from two tables with different granularity

    You need to create a Customer dimension which filters both tables. Then you can slice easily by Customer.

    In the link I pasted there're also techniques which explain how not to display the...
  14. Re: Using data from two tables with different granularity

    Hi Charlklands

    I cannot be of help without seeing your data. If you post some sample data then I can take look otherwise you could take a look at:...
  15. Replies
    15
    Views
    3,033

    Re: It was twenty years ago today...

    Thank you, Bill. It's great to be part of MrExcel community
  16. Replies
    3
    Views
    508

    Re: Help with power query

    Hi dj, yes you can have another workbook file as the source of your query
  17. Re: PowerPivot - Timings ignoring down hours from another table

    You can get the file here: https://1drv.ms/x/s!AiiWkkwHZChHjzZc2WmnCMahT0xz

    Look at the transformations done in the Query Editor
  18. Replies
    3
    Views
    508

    Re: Help with power query

    Hi dj,

    that is not possible to do. Every time you update a query the whole table is refreshed, which I think is a great thing!
  19. Re: PowerPivot - Timings ignoring down hours from another table

    Hi Harvey,

    I am getting 1,113 minutes for the below:



    Can you tell me how you come up with 1,060? I am getting 1,020 minutes for January 4th and 93 minutes for January 5th.
  20. Re: PowerPivot - Timings ignoring down hours from another table

    Hi Harvey could you post a data which can be copy pasted?
  21. Replies
    5
    Views
    718

    Re: Power Query - Remove Duplicates

    I guess leftanti canalso be used in your case, First you would perform a leftAnti join and then remove rows where XX is not empty
  22. Replies
    5
    Views
    718

    Re: Power Query - Remove Duplicates

    Hi joslaz

    you have Table.IsEmpty because the the current row you are looking at must not be associated with any cancellations

    The optimization of your code depends on the layout of your data,...
  23. Re: DAX measure using values across tables...

    You conversion data table has unique rows so you just need to add an index column which serves are PrimaryKey



    let Source =...
  24. Replies
    5
    Views
    718

    Re: Power Query - Remove Duplicates

    You can do it like this,



    let
    // load data
    Source =...
  25. Re: DAX measure using values across tables...

    Hi Matty

    you should always make use of physical relationships whenever possible, it is true you can use DAX to 'create a relationship' on the fly but physical relationships are generally much...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4