Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. 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. 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. 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. 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. 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/
  6. 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...
  7. Replies
    1
    Views
    628

    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. 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.
  9. Replies
    2
    Views
    799

    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. 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. 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. 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. 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
  14. Replies
    2
    Views
    1,045

    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. 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.
    ...
  16. 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 -...
  17. Re: Power Query - Remove duplicates from Folder Download

    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. 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. Replies
    1
    Views
    609

    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. 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. Replies
    3
    Views
    1,020

    Re: Is Power Query what I need?

    +1 pq
  22. Replies
    3
    Views
    711

    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. Replies
    3
    Views
    711

    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. 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. 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 2 3 4