Search found 985 matches

by MattAllington
Sun Sep 23, 2018 7:24 am
Forum: PowerPivot/DAX
Topic: Help with DATEDIFF function
Replies: 3
Views: 123

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: 34

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: 25

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: 123

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: 100

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: 100

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...
by MattAllington
Mon Sep 17, 2018 7:37 am
Forum: PowerPivot/DAX
Topic: SUMX Giving Incorrect Grand Total
Replies: 9
Views: 337

Re: SUMX Giving Incorrect Grand Total

It is currently not possible to change the headings in a table based on a slicer. You could write a new measure and put it in a card above the heading if you like. something like this (you will have to change the table and column names)

=SELECTEDVALUE(Table[C2])
by MattAllington
Tue Sep 11, 2018 6:47 am
Forum: PowerPivot/DAX
Topic: SUMX Giving Incorrect Grand Total
Replies: 9
Views: 337

Re: SUMX Giving Incorrect Grand Total

The formula you have pasted is not the one I provided. You are missing a close bracket before the divide and you have an extra one at the end
by MattAllington
Tue Sep 11, 2018 6:25 am
Forum: Power Query
Topic: Max query with second condition [Solved]
Replies: 2
Views: 93

Re: Max query with second condition [Solved]

Just put a filter to remove the zeros, then group by and take the first record.
by MattAllington
Mon Sep 10, 2018 7:08 pm
Forum: PowerPivot/DAX
Topic: SUMX Giving Incorrect Grand Total
Replies: 9
Views: 337

Re: SUMX Giving Incorrect Grand Total

Sorry, I can’t tell from what you have pasted what the issue is. Can you just paste the exact formul you are typing?

Go to advanced search