Search found 61 matches

by andredl
Tue Aug 10, 2021 12:32 pm
Forum: Power Query
Topic: Extract static data from data models in other Power Pivot workbooks
Replies: 3
Views: 576

Re: Extract static data from data models in other Power Pivot workbooks

Thanks Phil, yes this is the problem I'm facing. I know how to do it if I go into each of the files, pivot up the results in the data model to be visible in a pivot table, then query the sheets from a different workbook, but I was hoping there's a less tedious solution out there. Given how easy PQ m...
by andredl
Mon Aug 02, 2021 9:48 am
Forum: Power Query
Topic: Extract static data from data models in other Power Pivot workbooks
Replies: 3
Views: 576

Extract static data from data models in other Power Pivot workbooks

Hi, Does anyone know of a way to extract static data that has been loaded into a power pivot data model in one workbook, into a separate workbook, without refreshing the original query that was the source of the data in the first workbook? I have set up a scheduled refresh of a query to run and save...
by andredl
Tue Jul 03, 2018 12:49 pm
Forum: PowerPivot/DAX
Topic: Issue with Data Model
Replies: 7
Views: 8817

Re: Issue with Data Model

It might help to isolate the problem in terms of where it exists, i.e. the workbook itself, or your installation of Office. Try running the workbook on a different computer that supports Power Pivot/PQ, and if it still fails, it's probably a workbook problem. If it doesn't, it might help to do a com...
by andredl
Tue Jul 03, 2018 12:41 pm
Forum: PowerPivot/DAX
Topic: Distributing invoice value against product batches
Replies: 1
Views: 1517

Re: Distributing invoice value against product batches

Hi, I would recommend loading both the blend table and the invoices table into your data model, and then using Power Query to create a bridging table containing distinct values of the batch/blend numbers. This allows you to create relationships from both the batch table and the invoice table to the ...
by andredl
Tue Jul 03, 2018 10:17 am
Forum: PowerPivot/DAX
Topic: Issue with Data Model
Replies: 7
Views: 8817

Re: Issue with Data Model

I run into this sort of problem from time to time, the only solution I have found to work, is to have multiple backup copies, so that when your file becomes corrupted, you have a previous version to rely on. You could also try re-building the model in a new workbook, copying the M-code from all your...
by andredl
Mon Jul 02, 2018 2:10 pm
Forum: Power Query
Topic: Append subset of columns
Replies: 1
Views: 2717

Re: Append subset of columns

Hi Ian, ...As far as I can see the Append function only really works when the two queries have the same number of columns. This isn't the case, you can have two queries with different numbers of columns, but for the appropriate columns to append correctly, the column heading descriptions have to be ...
by andredl
Mon Jul 02, 2018 12:53 pm
Forum: Power BI Desktop/Service
Topic: [Solved] Showing All Customers in a Table with Multiple Measures
Replies: 5
Views: 4546

Re: Showing All Customers in a Table with Multiple Measures

Hazdiggity {L_WROTE}{L_COLON}That does it! Thanks andredl - good trick!

You're welcome :)
Would you mind editing the topic text to include the word [Solved] to indicate it has been solved?
Cheers,
André
by andredl
Mon Jul 02, 2018 11:56 am
Forum: Power BI Desktop/Service
Topic: [Solved] Showing All Customers in a Table with Multiple Measures
Replies: 5
Views: 4546

Re: Showing All Customers in a Table with Multiple Measures

Just an idea, but if you were to add a measure to your matrix, call it Test = ISFILTERED(CustomerTable[Customers]), does that give you the behaviour you want? It should add a column showing TRUE next to all the customers in your lookup table, but the slicers will still work.
by andredl
Mon Jul 02, 2018 8:57 am
Forum: PowerPivot/DAX
Topic: Problem with calculation of total on different hierarchy levels in DAX
Replies: 1
Views: 1634

Re: Problem with calculation of total on different hierarchy levels in DAX

Have you tried using SUMX across the values in your hierarchy for which you want the total to be aggregated? From what I can tell, Customer Attitude, Professionality and Time are all values in the column labelled SurveyQuestionsAnswers[ModelName]. You want the total (Service Quality) of RelativeEsti...
by andredl
Sun Jul 01, 2018 6:06 pm
Forum: Power BI Desktop/Service
Topic: Calculate a column help
Replies: 1
Views: 2380

Re: Calculate a column help

Assuming your data table is called "NumDays", which is what I understand from your description, and that you want the frequency (count) of each value appearing in the column labelled "KEY1", which is again what I understand from your description, you can get this count in a calcu...

Go to advanced search