m code

  1. S

    Power query refresh running unusably slow.

    Hi all, I have several data files in a standard format (xlsx files, 1 tab (all named the same), 4 columns of data each (all common headers(Owner, Supplier, Amount and Account)) - varying numbers of rows in each. These files are in a folder on sharepoint (no option to save these outside of...
  2. D

    M code Occurrence

    Hi, can someone explain the difference between Occurrance.All and Occurrance.Repeating ? they both seem to to work the same and the documentation does not make the difference clear. Richard.
  3. I

    Split a .csv with multiple tables into multiple queries

    Hello, I am working with a .csv file produced by a proprietary application that includes 4 different tables all jammed together into a single file. Here is a link to a dummy version of that .csv to highlight how the tables are arranged. The key point is that each table has a different number of...
  4. ExcelAtEverything

    Change All Dates To Fridays in a Fri-Thu Week in Power Query

    Hello, I was wondering if anyone could help me with what is probably a very simple tweak. This currently takes a copy of my date column and changes all the dates to Sunday's date of whatever week that is. The trouble is that my weeks run Fri-Thu, so I need it to show the date of the Friday at...
  5. D

    M code and DAX running total

    Hello, pretty new to power query and dax, I've used < List.Sum list.firstN / Range and List.Accumulate to create running totals, and an index column in Dax power pivot but I'd like to create one based on a condition, so at simples two columns 'Product ' a b c and 'sales' and create a running...
  6. N

    Power Query - Calendar Table

    Good morning - I have a fiscal calendar that my company creates which I pull into Power BI. Columns include date, fiscal year, fiscal week, day of week, work day, holiday, holiday name, week of month, and fiscal quarter. What I want to do is creat a few custom column in power query that will...
  7. E

    Power query acumulate sum formula

    Im working in power query, I need to acumulate value per month and account. For january I like to only se value for janauray and then for february summed value for jan and feb and so on. Is there any formula that ca create the coulumn Acum Value below? <tbody> Account Period Value Acum Value...
  8. N

    Keep non related columns balnk when expanding a table after merging

    hi all, im new to power query and i am merging tables and expanding relevant columns. is there any way that keep cells / rows of non related columns blank or null when expanding another column ? please see attached images for clear understanding. i have highlighted few of duplicates happened...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top