Search found 922 matches

by MattAllington
Sat Mar 17, 2018 4:46 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: database import error
Replies: 2
Views: 76

Re: database import error

For the record, I sorted this for fatanalyst. Contact me at my website if you have a similar issue
by MattAllington
Wed Feb 28, 2018 5:36 am
Forum: PowerPivot/DAX
Topic: Relationship Cardinality
Replies: 2
Views: 194

Re: Relationship Cardinality

Very strange. I will be at Microsoft next week. I will add this to the list of things to follow up on (unless someone else knows.
by MattAllington
Sun Feb 25, 2018 6:47 pm
Forum: PowerPivot/DAX
Topic: Lookup formula from excel to dax
Replies: 1
Views: 152

Re: Lookup formula from excel to dax

This is not enough Information for anyone to help you.
by MattAllington
Wed Feb 14, 2018 6:18 pm
Forum: PowerPivot/DAX
Topic: duplicates
Replies: 3
Views: 306

Re: duplicates

Maybe you could be a bit more specific?
by MattAllington
Mon Feb 05, 2018 6:35 am
Forum: General
Topic: Error Message
Replies: 2
Views: 355

Re: Error Message

What version of Excel? Excel 2016 is the most risky (I always keep incremental backups)

Read my article here Power Pivot Crashes
Maybe also try migrating the data model to Power BI as a way of saving it
by MattAllington
Thu Feb 01, 2018 7:18 am
Forum: PowerPivot/DAX
Topic: Measure to Sum the Lower Levels.
Replies: 2
Views: 390

Re: Measure to Sum the Lower Levels.

The issue is that you can't complete the calculation you are trying to do at the aggregate level. You need to do it line by line.

This should work =sumx(VALUES(Table1[Level 2 Prodcut]),([ASP 2a]-[ASP 1a])*[Qty 1])

To understand why, read my article SUM vs SUMX Explained
by MattAllington
Thu Feb 01, 2018 6:44 am
Forum: PowerPivot/DAX
Topic: Text to Decimal
Replies: 1
Views: 233

Re: Text to Decimal

Well you can't load data into a column in Power Pivot that has text and numbers AND have it marked as a numeric column. Same with any database actually. But DAX is a very forgiving language. If you were to add a Calculated Column to your table something like =IFERROR(VALUE(Table1[Text]),BLANK()) you...
by MattAllington
Mon Jan 22, 2018 7:45 am
Forum: PowerPivot/DAX
Topic: Quotas
Replies: 2
Views: 364

Re: Quotas

Do you mean like a budget? You can simply load another table. I have a few articles
here ... wer-pivot/
and here ... g-treatas/
by MattAllington
Fri Jan 12, 2018 8:41 am
Forum: Power Query
Topic: Data Normalization
Replies: 2
Views: 529

Re: Data Normalization

⋅ connect to the source data ⋅ set this query so it doesn't load. In PBI, right click and turn off "enable load". In Excel, "close and load", "Connection only" ⋅ go back into power query, right click on the above query, select "refere...

Go to advanced search