Search found 1155 matches

by MattAllington
Fri Mar 05, 2021 7:18 pm
Forum: Power Query
Topic: Studying Power Query, does this Data Model and relationships make sense?
Replies: 1
Views: 151

Re: Studying Power Query, does this Data Model and relationships make sense?

It’s hard to say from the picture. I would have thought transfers, transactions, credits and debits are all types of transactions and should be in a single, standardise fact table.
by MattAllington
Tue Feb 23, 2021 3:59 pm
Forum: PowerPivot/DAX
Topic: DISTINCTCOUNT Grand Total incorrect
Replies: 2
Views: 204

Re: DISTINCTCOUNT Grand Total incorrect

I’m on an iPad, so I can’t see your sample datamodel (just the pivot). At least conceptually, here is the problem with totalling distinctcount. Imagine you have sales by month by customer A,B,C Jan A=2 B=1 A=1 Feb A=4 C=3 How many distinct customers have purchased? Jan =2, Feb =2, right? But what do...
by MattAllington
Sat Feb 20, 2021 8:26 am
Forum: PowerPivot/DAX
Topic: Possible tweak to calendar ID last year calc
Replies: 1
Views: 47

Re: Possible tweak to calendar ID last year calc

This is a good approach if it helps. Another approach is to use Values(calendar[day of year]) to “harvest” which days of the year are in the current filter context. You can then to a time shift by removing all filters from the calendar, put a new filter on last year (by detecting the current year an...
by MattAllington
Wed Feb 17, 2021 6:33 am
Forum: PowerPivot/DAX
Topic: Formula working in Power BI but not in Power Pivot?
Replies: 1
Views: 55

Re: Formula working in Power BI but not in Power Pivot?

Check the data types of your columns to make sure they are not different in PP vs PBI.

Bonus tips
- read the error message that it gives when it doesn’t work
- consider if this should be a column or a measure https://exceleratorbi.com.au/calculated ... sures-dax/
by MattAllington
Fri Jan 29, 2021 6:17 pm
Forum: PowerPivot/DAX
Topic: slow perfomance summarize 15 minutes
Replies: 1
Views: 335

Re: slow perfomance summarize 15 minutes

I haven’t read you question in detail, but let me make an observation. I have a saying: If you come from a database background, every DAX problem looks like a DAX query. But the truth is, Power BI and DAX are not the same as a traditional database. In power BI, you should be modelling your data with...
by MattAllington
Sun Dec 27, 2020 7:01 am
Forum: PowerPivot/DAX
Topic: Counting responses in rows - multiple text strings needs to be ignored
Replies: 2
Views: 238

Re: Counting responses in rows - multiple text strings needs to be ignored

I suggest you split the responses into rows. You can do this in power query using the split columns by delimiter feature. Just make sure you select “to rows”. Then you table will have one row for each answer.
by MattAllington
Sun Dec 27, 2020 6:58 am
Forum: PowerPivot/DAX
Topic: Average of two pivot columns
Replies: 2
Views: 464

Re: Average of two pivot columns

This is not enough information to be able to help you
by MattAllington
Sun Dec 20, 2020 7:59 am
Forum: Power BI Desktop/Service
Topic: How do i calculate the variance between 2 matrix columns based on slicer selections?
Replies: 1
Views: 892

Re: How do i calculate the variance between 2 matrix columns based on slicer selections?

I assume you have a column for scenario. I would create 2 disconnected tables of the scenario names. Write 2 measures that respond to these selections (one to each). Something like this VAR selectedScenario = selectedvalue(disconnectedTable1[scenario]) Return CALCULATE(Base measure],datatable[scenar...
by MattAllington
Mon Nov 30, 2020 5:58 pm
Forum: PowerPivot/DAX
Topic: Complex ask - help with strategy/technique/formula
Replies: 4
Views: 396

Re: Complex ask - help with strategy/technique/formula

Mmmmm, I’m having second thoughts now. Does each project have the 3 date columns in your data against a single row in the table (ie the row for each project)?

Go to advanced search

cron