Search found 818 matches

by MattAllington
Tue Jun 27, 2017 4:50 pm
Forum: Power Query
Topic: Issue with Dates in Column heading
Replies: 3
Views: 21

Re: Issue with Dates in Column heading

I don't have plans for Power Query live training as I think this subject lends itself very nicely to video training. Power Pivot is different because it is quite tricky in places and needs some live instruction. Even my online Power Pivot classes have a "live" component, but I don't think ...
by MattAllington
Tue Jun 27, 2017 9:28 am
Forum: Power Query
Topic: Issue with Dates in Column heading
Replies: 3
Views: 21

Re: Issue with Dates in Column heading

How about pre-pending "1-" in front of the data in the column before converting to date?
by MattAllington
Mon Jun 26, 2017 7:12 am
Forum: PowerPivot/DAX
Topic: Basic relationship between 2 tables
Replies: 1
Views: 35

Re: Basic relationship between 2 tables

Welcome to Power Pivot/Power BI. There is a lot to learn. Have a look at my article here https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/ Columns from the table on the 1 side of the relationship will filter the table on the many side of the relationship, but not the other way aro...
by MattAllington
Mon Jun 26, 2017 7:09 am
Forum: PowerPivot/DAX
Topic: Confused on How To Make a Relationship Between two workbooks
Replies: 1
Views: 34

Re: Confused on How To Make a Relationship Between two workbooks

You can't make relationships BETWEEN workbooks. You must bring the data into a single workbook. Create a new blank workbook, then import the data from Customer1, then bring in the table from Customer2. You can either import directly from Power Pivot or you can use Power Query. If you use Power Query...
by MattAllington
Thu Jun 22, 2017 7:54 am
Forum: PowerPivot/DAX
Topic: Modifying Query Context with ALL()?
Replies: 5
Views: 228

Re: Modifying Query Context with ALL()?

values can return a table or a value (if there is only 1 row in the table). If it returns a table, then the SWITCH function will fail (switch needs a value not a table). So you need to protect the formula so that it is guaranteed to return a value, not a table. That is what HASONEFILTER is effective...
by MattAllington
Mon Jun 19, 2017 7:24 am
Forum: PowerPivot/DAX
Topic: Modifying Query Context with ALL()?
Replies: 5
Views: 228

Re: Modifying Query Context with ALL()?

You need a filter on Calendar[Year] if you want ALLEXCEPT to work. If there is no filter on Calendar[Year], then ALLEXCEPT will be the same as ALL.
by MattAllington
Sun Jun 18, 2017 7:53 am
Forum: PowerPivot/DAX
Topic: One-to-One Relationships and Diagram View
Replies: 2
Views: 58

Re: One-to-One Relationships and Diagram View

You can't do it in Excel. Only in Power BI Desktop
by MattAllington
Thu Jun 15, 2017 8:12 am
Forum: PowerPivot/DAX
Topic: Modifying Query Context with ALL()?
Replies: 5
Views: 228

Re: Modifying Query Context with ALL()?

Firstly let me complement you on providing clear information. If you help me to help you, you will definitely get more help from me :-). Now, first some advice. Give your tables a name that mean something to your end users. eg don't call it dCalendar but call it Calendar. Don't call it fSales but ca...
by MattAllington
Wed Jun 14, 2017 10:03 am
Forum: PowerPivot/DAX
Topic: I edit connection but after: "We couldn't refresh the connection"
Replies: 15
Views: 416

Re: I edit connection but after: "We couldn't refresh the connection"

Sorry, I can't help any further. It is difficult to help without seeing the problem.

Go to advanced search