PowerPivot Forum

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...

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...

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...

see attached.

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

Cheers
Phil

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...

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...

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 -...

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...

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

Cheers
Phil

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...