Search found 195 matches

by PhilC
Tue Mar 19, 2019 12:55 pm
Forum: PowerPivot/DAX
Topic: Delivery Performance Order Level
Replies: 1
Views: 62

Re: Delivery Performance Order Level

Hi KRAPANAT, Attached is a file that might assist. 1. Calculated the # Orders 2. Calculated the # Delayed Orders (based on On time Indicator = 0) 3. Used these to derive the On Time Percentage being (# Orders - # Delayed Orders) / # Orders I suspect there is a more elegant approach but this might ge...
by PhilC
Tue Mar 19, 2019 12:30 pm
Forum: PowerPivot/DAX
Topic: Many to Many Relationship
Replies: 2
Views: 107

Re: Many to Many Relationship

Hi Franz, I'd expect there is a better approach to this, but in lieu of someone else helping out you could try the attached. I have used Power Query to import the data and process it, before putting it into the data model. I'd suggest you always use Power Query to get data into the model rather than...
by PhilC
Mon Mar 18, 2019 8:58 am
Forum: PowerPivot/DAX
Topic: Does this require CONTAINS()?
Replies: 1
Views: 34

Re: Does this require CONTAINS()?

Hi Bel Would one of these in and IF statement help you? https://docs.microsoft.com/en-us/dax/search-function-dax https://docs.microsoft.com/en-us/dax/find-function-dax FIND is case sensitive, SEARCH is not Use a SUMX as you need to do the test on each row first, and only sum those that meet the test...
by PhilC
Mon Mar 18, 2019 8:51 am
Forum: Power Query
Topic: Particular transposition of rows in columns
Replies: 5
Views: 224

Re: Particular transposition of rows in columns

see attached.

Might be a few errors in the suggested answer tab you provided (see Arsenal Week 3).

Cheers
Phil
by PhilC
Mon Mar 18, 2019 8:30 am
Forum: Power Query
Topic: Remove Rows in TXT file
Replies: 1
Views: 54

Re: Remove Rows in TXT file

Hi oluskaaa123, Below are a few links to show you how to combine multiple files from a folder in Power Query. https://powerpivotpro.com/2015/01/power-query-for-excel-combine-multiple-files-of-different-file-types/ https://www.myexcelonline.com/blog/consolidate-multiple-excel-workbooks-using-power-qu...
by PhilC
Mon Mar 18, 2019 7:24 am
Forum: PowerPivot/DAX
Topic: My formula is not agregating correclty on my rank
Replies: 2
Views: 56

Re: My formula is not agregating correclty on my rank

Hi, Have a look at the following. https://www.youtube.com/watch?v=Ka7Ds4EAjNQ https://www.sqlbi.com/articles/use-of-rankx-in-power-bi-measures/ https://powerpivotpro.com/2012/03/subtotals-and-grand-totals-that-add-up-correctly/ The first explains (a bit clumsily) why you are seeing the results you a...
by PhilC
Mon Mar 18, 2019 6:53 am
Forum: PowerPivot/DAX
Topic: Calculating the average with different conditions/filters
Replies: 1
Views: 60

Re: Calculating the average with different conditions/filters

Hi Jennifer, can you please post the data (Excel file) so we have a starting point to provide assistance. In terms of creating a solution, break it down into the aspects needed: - filter for Status = "Status 1" - exclude it only one Status 1 value on day - identify the last Status 1 time -...
by PhilC
Thu Mar 07, 2019 7:06 am
Forum: Power BI Desktop/Service
Topic: Calendar does not work
Replies: 7
Views: 337

Re: Calendar does not work

Hi, The beauty of DAX is that once the model is in place you can perform actions on one table and by virtue of the linked tables, the filters flow down and act on the other tables. have a look at this post from Matt Allington (who runs this forum): https://exceleratorbi.com.au/best-practices-power-p...
by PhilC
Wed Mar 06, 2019 12:09 pm
Forum: Power BI Desktop/Service
Topic: Calendar does not work
Replies: 7
Views: 337

Re: Calendar does not work

Power BI file attached, with a simple COUNTROWS measure added.

Cheers
Phil
by PhilC
Wed Mar 06, 2019 12:08 pm
Forum: Power BI Desktop/Service
Topic: Calendar does not work
Replies: 7
Views: 337

Re: Calendar does not work

Thanks for providing the PBIX file, definitely an interesting dataset to be analysing. To do anything meaningful with this, you will need to start using measures, not just dragging a field into the values area of a visual. I mentioned below to google the difference between implicit and explicit meas...

Go to advanced search

cron