Search found 989 matches

by MattAllington
Mon Oct 15, 2018 8:53 am
Forum: Power Query
Topic: Power query - query first of prioritized group
Replies: 1
Views: 25

Re: Power query - query first of prioritized group

I don't understand what you are asking. Yes, it is possible to sort on one or more columns and then select the first item that appears in the table.
by MattAllington
Tue Oct 09, 2018 6:42 am
Forum: PowerPivot/DAX
Topic: Issue with Learn to write DAX
Replies: 1
Views: 68

Re: Issue with Learn to write DAX

This is a known bug with some versions of Excel. It should work, but it doesn't. What version of Excel are you using?

Unfortunately you will have to skip this process or reload the table if you want to make changes.
by MattAllington
Wed Oct 03, 2018 5:29 am
Forum: Power Query
Topic: New rows in table not formatted as Date
Replies: 2
Views: 120

Re: New rows in table not formatted as Date

I have seen this too - very frustrating. I haven't been able to solve it with the few files I have, but now I hear that you have a problem with some files and not other, I wonder if you remove the table (set data load to connection only) and then add it back in a clean sheet, how that would work out...
by MattAllington
Tue Oct 02, 2018 6:56 am
Forum: Power Query
Topic: Power query - join kind not showing
Replies: 1
Views: 71

Re: Power query - join kind not showing

I’ve never seen this before. I am wondering if you have any duplicates in either of the columns to be joined. Just a hunch, but maybe if there are no duplicates, then only an inner join works. Apart from that, I have no idea.
by MattAllington
Sun Sep 23, 2018 7:24 am
Forum: PowerPivot/DAX
Topic: Help with DATEDIFF function
Replies: 3
Views: 198

Re: Help with DATEDIFF function

Yes it makes sense, although I don't get why "contracts" are called "Budgets" :-). What format do you want the output in? Do you want a list of the contracts in a pivot table with the number of overlapping days displayed based on the period selected? What should the total do? Add...
by MattAllington
Sun Sep 23, 2018 7:10 am
Forum: Power Query
Topic: Power Query
Replies: 1
Views: 129

Re: Power Query

On the home tab there is a button "Replace Values". Simply replace the underscore character with a space character
by MattAllington
Fri Sep 21, 2018 7:57 am
Forum: PowerPivot/DAX
Topic: Combine 2 pivot tables into one pivot table
Replies: 1
Views: 74

Re: Combine 2 pivot tables into one pivot table

You can't combined 2 pivot tables. A pivot table is a visualisation tool for data. You need to combine the underlying data. You can do that in Power Pivot.
by MattAllington
Fri Sep 21, 2018 7:56 am
Forum: PowerPivot/DAX
Topic: Help with DATEDIFF function
Replies: 3
Views: 198

Re: Help with DATEDIFF function

I realise you didn't write this, but I can almost guarantee that this is the wrong approach. Can you take a step back and explain what data you have and what you are trying to do here. It is highly likely there is a better approach than this formula.
by MattAllington
Wed Sep 19, 2018 7:27 am
Forum: PowerPivot/DAX
Topic: Complete date table in ACCESS
Replies: 6
Views: 331

Re: Complete date table in ACCESS

If you don't have it, please download the sample files from my website again https://exceleratorbi.com.au/supercharg ... /#download There is a file called 7 tables in that zip file
by MattAllington
Mon Sep 17, 2018 8:21 am
Forum: PowerPivot/DAX
Topic: Complete date table in ACCESS
Replies: 6
Views: 331

Re: Complete date table in ACCESS

I understand why you are asking. Marco Russo keeps telling me that the calendar table should go to the end of the year. I don't have that, but I have an Excel version in the download that you can extend yourself if you like. FYI, I have written hundreds of formulas using the current incomplete calen...

Go to advanced search