# Search:

Type: Posts; User: Matt Allington; Keyword(s):

Page 1 of 6 1

## Search: Search took 0.06 seconds.

by Matt Allington
Replies
1
Views
29

At a guess.
1 Add a new Merged column using the 3 columns to make a unique key
2 branch the query and do a group by the key, distinct count of the file name
3 filter where count >1. This is a...
2. ## Thread: Dynamic DAX calculation between two rows of same DAX measure (filtered rows)

by Matt Allington
Replies
2
Views
16

### Re: Dynamic DAX calculation between two rows of same DAX measure (filtered rows)

If the June and July cycle are actual sales up until June, why are the numbers different for periods Jan x Jun?
3. ## Thread: Employee turnover calc

by Matt Allington
Replies
1
Views
43

### Re: Employee turnover calc

This is a non trivial task. I suggest you read up on “events in progress” https://blog.gbrueckl.at/2014/12/events-in-progress-for-time-periods-in-dax/. You need to be clear how the % turnover is...
4. ## Thread: Equivalent of DATESBETWEEN(LASTDATE... ?

by Matt Allington
Replies
2
Views
403

### Re: Equivalent of DATESBETWEEN(LASTDATE... ?

Datesbetween is an inbuilt time intelligence function. To use it, you must
1. Have a calendar table. https://exceleratorbi.com.au/power-pivot-calendar-tables/
2. The first parameter must be the...
5. ## Thread: Is Power Query what I need?

by Matt Allington
Replies
3
Views
799

+1 pq
6. ## Thread: Eliminate zombie employees

by Matt Allington
Replies
3
Views
542

### Re: Eliminate zombie employees

Yes, this helps. Creating sample data, loading into a model, making sure that the sample data is a suitable set to test etc, is all part of the process of solving a problem. These steps often take...
7. ## Thread: Eliminate zombie employees

by Matt Allington
Replies
3
Views
542

### Re: Eliminate zombie employees

DAX formulas always depend on the table structure. How about you post a typical sample workbook showing the structure and current formulas.
8. ## Thread: Which histogram formula is correct?

by Matt Allington
Replies
1
Views
391

### Re: Which histogram formula is correct?

The first one is counting the line level items, not the aggregation of all lines in a PO. Have you tried taking the first one, and replace “orders” with “values(orders[PO no.])”
9. ## Thread: Missing report tabs

by Matt Allington
Replies
1
Views
471

### Re: Missing report tabs

Save, close power BI and reopen again. It is a known bug

by Matt Allington
Replies
1
Views
566

Search for “drill through filter power BI”.
11. ## Thread: Count of new customers

by Matt Allington
Replies
1
Views
493

### Re: Count of new customers

It is all here https://www.daxpatterns.com/new-and-returning-customers/
12. ## Thread: PowerBI Dataflows (cant see it in the service)

by Matt Allington
Replies
1
Views
420

### Re: PowerBI Dataflows (cant see it in the service)

Probably because you are in “my workspace”. They only exist in App Workspaces.
13. ## Thread: Power Pivot CALCULATE vs. RELATEDTABLE

by Matt Allington
Replies
2
Views
429

### Re: Power Pivot CALCULATE vs. RELATEDTABLE

Don’t do any of these. Use measures instead.
https://exceleratorbi.com.au/calculated-columns-vs-measures-dax/

by Matt Allington
Replies
4
Views
178

### Re: Members Upload Files to Workspace at powerbi.com?

I think the process is the same for V1 and V2.
Click on Workspaces > to expand menu
find the workspace, click on the ellipsis ...
Workspace access
you can add new users or change user access...
15. ## Thread: Expression Error: The key didn't match any rows in the Table

by Matt Allington
Replies
1
Views
653

### Re: Expression Error: The key didn't match any rows in the Table

The error means you are trying to do something, but it doesn’t exist. Eg it is trying to import a sheet called “sheet1” but there is no “sheet1” to be found in the table. If you are combining files,...
16. ## Thread: Assign a characteristic to a measure Power Pivot

by Matt Allington
Replies
1
Views
387

### Re: Assign a characteristic to a measure Power Pivot

In short, no.

I assume these mean cash flow, profit and loss, balance sheet. If yes, watch this video.
17. ## Thread: Calculate with rows filter

by Matt Allington
Replies
4
Views
604

### Re: Calculate with rows filter

It depends on your table structure. If all 3 columns above are in the same table, just drags the ID and Name to rows of the pivot, drags the first column to values, and change he pivot table layout...

by Matt Allington
Replies
4
Views
178

### Re: Members Upload Files to Workspace at powerbi.com?

Hi Mike. Are you using the new preview workspace format (v2)? This will be GA in a few weeks. Have you tried adding people as contributors? I think that will fix it.

by Matt Allington
Replies
7
Views
694

### Re: Doble condition

then just replace the stock number with the date-time

SOH =SUMX ( VALUES ( Stock[IdProduct] ),
CALCULATE (
SUM ( Stock[Stock] ),
FILTER ( ALL ( Stock[date-time] ),...
20. ## Thread: Matrix with DoD (trending data) w/ 7 Day and 14 Day volume change

by Matt Allington
Replies
5
Views
535

### Re: Matrix with DoD (trending data) w/ 7 Day and 14 Day volume change

This is an asymmetrical matrix which is harder to do. You could probably do it using a disconnected table to pass the measures, similar to this....

by Matt Allington
Replies
7
Views
694

### Re: Doble condition

It is nothing to do with Excel. I can't open your Excel workbook (it says it is corrupt), but I could copy it to Power BI. This is what you need to do.
1. split the date and time into 2 separate...
22. ## Thread: Import Several csv files into Power Pivot

by Matt Allington
Replies
2
Views
161

### Re: Import Several csv files into Power Pivot

Read my article on how to combine csv files with power query
23. ## Thread: Refreshing Blank Query - Duplicates

by Matt Allington
Replies
1
Views
403

### Re: Refreshing Blank Query - Duplicates

Power Query will load all the data in the source, once and only once. When new data arrives at the source, Power Query deletes all data previously loaded and reloads everything again including the...

by Matt Allington
Replies
7
Views
694

### Re: Doble condition

Well you will have to try a few things. The basic pattern is

LAST Stock =VAR laststock= MAX ( Table[DATE] )
RETURN
CALCULATE (
SUM ( tables[stock]),
'DATE'[DATE] =...
25. ## Thread: Power Query - import multiple files from SharePoint

by Matt Allington
Replies
3
Views
307

### Re: Power Query - import multiple files from SharePoint

Have you tried clearing your credentials from Power Query and trying again? They are under data source settings. Also check that you are using the main URL for Sharepoint, not the link to the...
Results 1 to 25 of 150
Page 1 of 6 1