Search found 1025 matches

by MattAllington
Wed Mar 13, 2019 7:02 pm
Forum: PowerPivot/DAX
Topic: Cubeformula returning #NA
Replies: 8
Views: 164

Re: Cubeformula returning #NA

OK, great. I will be at Microsoft's office in Redmond next week, so if you can get something to me by early next week then chances are I will be sitting across from the right people to show.
by MattAllington
Wed Mar 13, 2019 4:32 pm
Forum: PowerPivot/DAX
Topic: Cubeformula returning #NA
Replies: 8
Views: 164

Re: Cubeformula returning #NA

I think MS genuinely wants to fix bugs. The issue is finding a workbook with a reproducible error. If you can provide that to me, I will pass it on to them.
by MattAllington
Tue Mar 12, 2019 5:06 pm
Forum: PowerPivot/DAX
Topic: Cubeformula returning #NA
Replies: 8
Views: 164

Re: Cubeformula returning #NA

How confidential is the data? Can you share it with me/Microsoft? I know the team that maintains the code. I have previously given them workbooks with reproducible errors and they have fixed the bug.
by MattAllington
Tue Mar 12, 2019 6:18 am
Forum: PowerPivot/DAX
Topic: Cubeformula returning #NA
Replies: 8
Views: 164

Re: Cubeformula returning #NA

If there are no slicers involved, then it sounds like a bug. It could be anything, including a memory issue. Sorry, I suspect this won’t be an easy fix.
by MattAllington
Wed Mar 06, 2019 9:19 am
Forum: PowerPivot/DAX
Topic: Kilometer consumption of each car
Replies: 2
Views: 91

Re: Kilometer consumption of each car

I suggest you read my article here. https://exceleratorbi.com.au/fill-table-with-last-survey-result/ If you take the approach above, you should always be able to get the latest version of the mileage and the previous version regardless of the date filter. I am not 100% that this will help you do wha...
by MattAllington
Sun Mar 03, 2019 6:40 am
Forum: PowerPivot/DAX
Topic: splitting values week by week between start and end date
Replies: 3
Views: 188

Re: splitting values week by week between start and end date

There are 2 ways I can think of. Add a calculated column that works out the daily rate, then use a virtual filter similar to what I cover here https://powerpivotpro.com/2016/12/how-many-working-days-has-an-employee-been-off-work/ The other way is to use power query to generate the daily records. I g...
by MattAllington
Sat Jan 26, 2019 7:47 am
Forum: PowerPivot/DAX
Topic: YTD Formula problem
Replies: 1
Views: 206

Re: YTD Formula problem

You haven’t provided enough info to receive help.
What are your formulas? What tbakes are involved and how are they joined?
by MattAllington
Tue Jan 22, 2019 6:28 am
Forum: Testing
Topic: Testing URL
Replies: 5
Views: 1092

Re: Testing URL

Test
by MattAllington
Mon Jan 21, 2019 6:29 am
Forum: Testing
Topic: Testing URL
Replies: 5
Views: 1092

Re: Testing URL

test
by MattAllington
Sat Jan 19, 2019 5:14 am
Forum: PowerPivot/DAX
Topic: Relating data from two different periods
Replies: 1
Views: 312

Re: Relating data from two different periods

I realise this is old, but here is a reply. There are a few approaches that are more or less pure in design. The simplest (not pure, but simple) is to append the 2 tables together and load the 2017 data for the month of Jan. Technically this is not true, but you can the report on that month (Jan 201...

Go to advanced search