Search found 1015 matches

by MattAllington
Mon Jan 14, 2019 3:36 pm
Forum: Power BI Desktop/Service
Topic: Calendars, multiple date fields, and sum with variable filter dates
Replies: 1
Views: 29

Re: Calendars, multiple date fields, and sum with variable filter dates

you will definitely get different behaviour from the date column that has the relationship. Once you join the invoice table to the calendar table, you should use the date columns from the calendar table in your reports. This implies (as you have suggested) that the calendar table is actually an &quo...
by MattAllington
Wed Jan 02, 2019 8:22 am
Forum: PowerPivot/DAX
Topic: Doubt with weighted average, sumx not doing what I want [Solved]
Replies: 7
Views: 736

Re: Doubt with weighted average, sumx not doing what I want [Solved]

1-Where can I learn more about proper modelling? Tricky. I suggest reading this blog article I wrote data modelling in Power BI . The best book I know of is this one, but I think it is probably too detailed for what you need. https://www.sqlbi.com/blog/marco/2017/05/08/the-new-data-modeling-book-for...
by MattAllington
Tue Jan 01, 2019 7:52 am
Forum: PowerPivot/DAX
Topic: Doubt with weighted average, sumx not doing what I want [Solved]
Replies: 7
Views: 736

Re: Doubt with weighted average, sumx not doing what I want [Solved]

Well, I don't really understand to be honest, but have a look at what I have done. This is actually a data modelling issue, not a dax issue and hence why the entire data model is needed for context and to make sure the solution is designed correctly ExamplePowerpivot new approach.xlsx Also, I highly...
by MattAllington
Tue Jan 01, 2019 7:16 am
Forum: PowerPivot/DAX
Topic: Create Calculated Column COUNT RECORD ENTRIES FOR EACH ID BY ROUTING BRANCH
Replies: 1
Views: 200

Re: Create Calculated Column COUNT RECORD ENTRIES FOR EACH ID BY ROUTING BRANCH

Welcome to a whole new world. Generally speaking my advice is that you don’t think about this as “how do I replicate this Excel formula” but instead think about it as “I have a new tool, what is the best way to solve my problem”. I have a lot of articles that cover the basic concepts. https://excele...
by MattAllington
Sun Dec 30, 2018 8:53 am
Forum: PowerPivot/DAX
Topic: Doubt with weighted average, sumx not doing what I want [Solved]
Replies: 7
Views: 736

Re: Doubt with weighted average, sumx not doing what I want [Solved]

1. Good question - it's complicated. The syntax is SUMX(table,expression) It works one row at a time in a table (each row in the calendar table in this case) and for each row it works out the result of the expression. If there are 10 rows in the table then the expression is evaluated 10 times. After...
by MattAllington
Fri Dec 28, 2018 5:05 pm
Forum: PowerPivot/DAX
Topic: Doubt with weighted average, sumx not doing what I want [Solved]
Replies: 7
Views: 736

Re: Doubt with weighted average, sumx not doing what I want [Solved]

I suggest a month level calendar table with 1 row per month and the number of days in the month. Then write 3 measures so solve the problem. Break the problem into bits and solve each bit one at a time Have a look at this ExamplePowerpivot.xlsx = SUMX ( CalendarNew, CALCULATE ( SUM ( FactTable[Sched...
by MattAllington
Sun Dec 23, 2018 6:18 am
Forum: Power Query
Topic: power Query Premierleague.com
Replies: 5
Views: 516

Re: power Query Premierleague.com

OK. I don't know of any way to solve this problem with Power Query. The website seems to be using javascript to send a query to their DB and return the data into the page. This is not something that Power Query can do unfortunately.
by MattAllington
Sat Dec 22, 2018 6:53 am
Forum: Power Query
Topic: power Query Premierleague.com
Replies: 5
Views: 516

Re: power Query Premierleague.com

The link you posted doesn't work. Can you post the link you are using?
by MattAllington
Wed Dec 05, 2018 5:35 pm
Forum: PowerPivot/DAX
Topic: Stock Movements Report - Best Approach?
Replies: 8
Views: 574

Re: Stock Movements Report - Best Approach?

I don't see any stock movement in the table, just SOH. So therefore I guess you just want to compare any two dates SOH. I think this version does this. Hopefully it is self explanatory.
Stock Comparison - Day On Day (1).xlsx
(1.36 MiB) Downloaded 33 times
by MattAllington
Tue Dec 04, 2018 5:42 pm
Forum: Power Query
Topic: Structuring Power Query for performance
Replies: 3
Views: 360

Re: Structuring Power Query for performance

Check this out first and see if it helps. https://exceleratorbi.com.au/how-query-folding-works/

If this is not the issue, then it can be quite complex. Post back how you go.

Go to advanced search

cron