m code

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...

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.

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...

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...

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...

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...

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...

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...