Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    1
    Views
    366

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

    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”,...
  4. 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
  5. 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...
  6. 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/
  7. 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
  8. Replies
    2
    Views
    976

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

    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.
    ...
  10. 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 -...
  11. 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...
  12. 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?
  13. Replies
    1
    Views
    566

    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...
  14. 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...
  15. Replies
    3
    Views
    984

    Re: Is Power Query what I need?

    +1 pq
  16. Replies
    3
    Views
    645

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

    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.
  18. 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.])”
  19. Replies
    1
    Views
    515

    Re: Missing report tabs

    Save, close power BI and reopen again. It is a known bug
  20. Replies
    1
    Views
    658

    Re: Page Navigation

    Search for “drill through filter power BI”.
  21. Replies
    1
    Views
    619

    Re: Count of new customers

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

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

    Don’t do any of these. Use measures instead.
    https://exceleratorbi.com.au/calculated-columns-vs-measures-dax/
  24. 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...
  25. 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,...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4