# Search:

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

Page 1 of 6 1

1. ## Thread: Need a Power bi Dax function to giving missing data in related table

by Matt Allington
Replies
1
Views
400

### Re: Need a Power bi Dax function to giving missing data in related table

Write this measure
Count of missing servers =countrows(filter(cmdb,calculate(countrows(table2))=0))

pit the server names on rows in a matrix/pivot and the measure in values.
2. ## Thread: Determination of the absence rate

by Matt Allington
Replies
3
Views
337

### Re: Determination of the absence rate

I wrote an article a few years ago that may help you. https://powerpivotpro.com/2016/12/how-many-working-days-has-an-employee-been-off-work/
3. ## Thread: Limitation on rules in power query

by Matt Allington
Replies
3
Views
444

### Re: Limitation on rules in power query

If you are trying to build a P&L, you should use a different approach. You need a chart of accounts that has all the account codes in a column, then extra columns for the roll ups. You also ideally...
4. ## Thread: Limitation on rules in power query

by Matt Allington
Replies
3
Views
444

### Re: Limitation on rules in power query

There is no doubt in my mind that there is a better way to do what you want to do. What are you trying to achieve?
5. ## Thread: Power Query - Changing Source

by Matt Allington
Replies
3
Views
600

### Re: Power Query - Changing Source

You have to be very careful. Read my article here https://exceleratorbi.com.au/understanding-power-query-combine/

by Matt Allington
Replies
1
Views
485

### Re: Dynamic slicer

You can’t add measures to slicers. If you are using power pivot for excel, that is the end of the story. If you are using PBI, you can add a measure as a filter on a slicer in the filter bar on the...

by Matt Allington
Replies
1
Views
629

### Re: Relationships/Slicers help

What do you want/expect to happen to the enquiries table if you slice by a column in the bookings table? There would seem to be no relationship (logically) between these things. If you remove all...
8. ## Thread: Is it possible to teach Power BI a Text mining/analysis without using any platforms.

by Matt Allington
Replies
2
Views
787

### Re: Is it possible to teach Power BI a Text mining/analysis without using any platforms.

Yes, you can use both Python and R in Power BI. Increasingly there is tight integration with cognitive services too (as you have found). Excel is not a tool for semantic text manipulation.

by Matt Allington
Replies
2
Views
800

### Re: IF Clause

If you can’t change it at the source, then a calc column is fine. Try SWITCH as follows

=SWITCH(TRUE(),
table[column] in {“”A1,”A2”,”A3”,”A4”,”A5”}, “AA”,
table[column] in {“”A15,”A16”}, “Ab”,...
10. ## Thread: How to make a DAX measure NOT to re-calculate on aggregated levels?

by Matt Allington
Replies
3
Views
656

### Re: How to make a DAX measure NOT to re-calculate on aggregated levels?

I'm happy to try to help, but you will need to provide more information
11. ## Thread: Delete rows if a condition is not met

by Matt Allington
Replies
1
Views
461

### Re: Delete rows if a condition is not met

You just use the filter buttons at the top of the table. Select one, and then apply the filter you need. If you need to filter logically across more than one column, you can add a new, custom column...
12. ## Thread: How to make a DAX measure NOT to re-calculate on aggregated levels?

by Matt Allington
Replies
3
Views
656

### Re: How to make a DAX measure NOT to re-calculate on aggregated levels?

You shouldn’t be using calculated columns (in my view). If you switch to measures, chances are you problems will disappear. https://exceleratorbi.com.au/calculated-columns-vs-measures-dax/
13. ## Thread: How to Add a Start & End Date Calendar Boxs to Pwer Bi Dashboard?

by Matt Allington
Replies
2
Views
818

### Re: How to Add a Start & End Date Calendar Boxs to Pwer Bi Dashboard?

If you add a slicer to the date column, it should give you a slider that can be set to do what you want

by Matt Allington
Replies
2
Views
1,048

### Re: Add time since 1900

This is pretty common. Just convert the seconds to days /60 /60 /24. You can then convert the days to a date by changing the data type.
15. ## Thread: Drill down by Week

by Matt Allington
Replies
1
Views
599

### Re: Drill down by Week

Are you talking about power BI? Power BI has an auto calendar table, but it doesn’t drill to weeks. You will need to create your own calendar table. You can read my article here.
...

by Matt Allington
Replies
1
Views
625

### Re: Adding multiple columns in Matrix columns

It seems your images didn't post on either thread. This makes it difficult for people to help you. I recommend you see if you can sort that out as there are lots of people willing to help for free -...

by Matt Allington
Replies
3
Views
429

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...
18. ## Thread: Dynamic DAX calculation between two rows of same DAX measure (filtered rows)

by Matt Allington
Replies
3
Views
631

### 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?
19. ## Thread: Employee turnover calc

by Matt Allington
Replies
1
Views
610

### 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...
20. ## Thread: Equivalent of DATESBETWEEN(LASTDATE... ?

by Matt Allington
Replies
2
Views
668

### 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...
21. ## Thread: Is Power Query what I need?

by Matt Allington
Replies
3
Views
1,022

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

by Matt Allington
Replies
3
Views
712

### 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...
23. ## Thread: Eliminate zombie employees

by Matt Allington
Replies
3
Views
712

### 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.
24. ## Thread: Which histogram formula is correct?

by Matt Allington
Replies
1
Views
531

### 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.])”
25. ## Thread: Missing report tabs

by Matt Allington
Replies
1
Views
588

### Re: Missing report tabs

Save, close power BI and reopen again. It is a known bug
Results 1 to 25 of 150
Page 1 of 6 1