Search found 20 matches

by Jonny1010101010
Thu Sep 26, 2019 4:41 pm
Forum: PowerPivot/DAX
Topic: Total Volume of Product That Contain X Material
Replies: 1
Views: 663

Total Volume of Product That Contain X Material

Hi all, I've been racking my brain over this one, but I'm not understanding the right way to manipulate the context - if anyone knows the simplest way? Scenerio - Table1 - Sales Volume by Product (fact table) Table2 - Product Bill Of Material, kgs of each material per sales kg (fact table) Table3 - ...
by Jonny1010101010
Tue Sep 10, 2019 5:46 am
Forum: PowerPivot/DAX
Topic: Simple DAX formula help [Solved]
Replies: 1
Views: 484

Re: Simple DAX formula help [Solved]

Hi,

I think you need the =COUNTROWS(Table) instead, and then bring in your 'Account' field as a filter context. I've attached an example.

Thanks, Jonny
by Jonny1010101010
Mon Sep 09, 2019 10:00 pm
Forum: PowerPivot/DAX
Topic: Consolidating identical data sets from two companies
Replies: 1
Views: 247

Re: Consolidating identical data sets from two companies

Hi,

Would you have a set of dummy information in the format you receive these reports so we can take a look? Remember not to share anything confidential.

Thanks, Jonny :D
by Jonny1010101010
Sat Sep 07, 2019 10:30 pm
Forum: PowerPivot/DAX
Topic: Finding The Right Schema - Data Model
Replies: 0
Views: 828

Finding The Right Schema - Data Model

Hi all, I'm trying to best schema for my product costing model. The complicating factor for me is that I have a large amount of fact tables which will be extending over time - each month there will be a new set of products, recipes, prices, etc which will relate to one together in their composite ti...
by Jonny1010101010
Sun Jun 16, 2019 4:28 pm
Forum: Power Query
Topic: List.Range & List.Sum M Formulas
Replies: 3
Views: 1798

Re: List.Range & List.Sum M Formulas

Hi all, I've realised why the M formula works in one situation and not the other, but I'm not sure of the technical logical as to why this is - if anyone can enlighten me that would be a great help! =List.Sum(List.Range( #"Added Index" [TimPerCase],0,[Index])) The section in bold is meant ...
by Jonny1010101010
Sun Jun 16, 2019 3:12 am
Forum: Power Query
Topic: List.Range & List.Sum M Formulas
Replies: 3
Views: 1798

List.Range & List.Sum M Formulas

Hi all, If someone is familiar with the correct way to use these two formulas as I'm having some difficult. I used the following formula (successfully!) to create a running total calculated column (of time stored as a decimal number): =List.Sum(List.Range(#Added Index"[TimePerCase],0,[Index])) ...
by Jonny1010101010
Sat Jun 15, 2019 9:49 pm
Forum: Power Query
Topic: Split Rows Of Entries Based On A Value
Replies: 3
Views: 736

Re: Split Rows Of Entries Based On A Value

Thank you PhilC! :) I've made alot of progress on this issue, and managed to get running total working in a way that works for me. The link you posted I had seen before and I was fairly intimidated by the approach, but I'm sure it would work too! I would recommend anyone trying to calculate a runnin...
by Jonny1010101010
Sat Jun 15, 2019 6:31 pm
Forum: Power Query
Topic: Split Rows Of Entries Based On A Value
Replies: 3
Views: 736

Re: Split Rows Of Entries Based On A Value

Think I've found the solution, unless anyone has a better suggestion! I can create a 'List' column by creating a custom column with ={1..[Case]) - surprisingly this does exactly what I need, eg SKU A gets split into 200 identical rows! Now I need to figure out how to get a running total of the time ...
by Jonny1010101010
Sat Jun 15, 2019 6:03 pm
Forum: Power Query
Topic: Split Rows Of Entries Based On A Value
Replies: 3
Views: 736

Split Rows Of Entries Based On A Value

Hi all, I'm working on a project where by a production plan are being allocated to 6 hour intervals of time throughout the week. In practice, however, due to the different unit demand and time per unit of the products, these 6 hour intervals are being drastically under / over allocated in terms of t...
by Jonny1010101010
Wed Dec 05, 2018 3:15 am
Forum: PowerPivot/DAX
Topic: Stock Movements Report - Best Approach?
Replies: 8
Views: 1698

Re: Stock Movements Report - Best Approach?

Hi,

Yes Matt, the edit you made describes what I'm looking to do. I've attached some mock data over about 30 days (edit: alot less actually - I couldn't upload the original file!) that I'm going to play with.

stock_table2.xlsx
(721.85 KiB) Downloaded 90 times


Thanks, Jonny

Go to advanced search

cron