+ Reply to Thread
Results 1 to 5 of 5

Calculating Days based on text criteria

  1. #1
    Registered User
    Join Date
    02-10-2021
    Location
    Montreal
    MS-Off Ver
    2016
    Posts
    4

    Calculating Days based on text criteria

    I have a feeling that this should be dead simple, but I'm new to power pivot and DAX formulas

    Working with power pivot, I have created a calculated column [Service Days] in a service history data table to calculate the number of days between the date a service was provided and Today.

    There are two categories of service in a column [Service Type] - High Touch and Low Touch.

    In the pivot table, I'm trying to figure out how to have a column showing the days since last service interaction for each customer (i.e. set the value field to return Min), but only for High Touch. Any suggestions please?

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,845

    Re: Calculating Days based on text criteria

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    02-10-2021
    Location
    Montreal
    MS-Off Ver
    2016
    Posts
    4

    Re: Calculating Days based on text criteria

    Thanks but unfortunately I can't make a sample file, since I use Office for Mac, which doesn't have Power Pivot. I'm running into the situation at work, where it isn't possible to export files or access this site.

  4. #4
    Registered User
    Join Date
    11-21-2017
    Location
    Hong Kong
    MS-Off Ver
    2013
    Posts
    21

    Re: Calculating Days based on text criteria

    Similar situation and just put the service type into columns field then hide the unwanted one. Probably not ideal.
    Last edited by winkywright; 02-17-2021 at 10:51 AM.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,845

    Re: Calculating Days based on text criteria

    Administrative Note:

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Calculating days worked based on occurences
    By JKAUFFMAN2019 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-03-2019, 10:38 AM
  2. [SOLVED] calculating months based on specified number of days
    By amartin575 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-25-2016, 10:47 AM
  3. Calculating rounded number of days based on totals
    By pmoby in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-25-2014, 05:28 AM
  4. calculating # of days based off dates
    By csiegel20 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-24-2014, 03:09 PM
  5. [SOLVED] Calculating a week of dates/days based on the beginning date entered...
    By tiffany04530 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 11-27-2012, 09:55 AM
  6. How to stop calculating based on criteria
    By liferg in forum Excel General
    Replies: 4
    Last Post: 07-10-2012, 07:37 PM
  7. Calculating based on calendar days
    By Pennypacker in forum Excel General
    Replies: 0
    Last Post: 02-19-2005, 04:28 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1