+ Reply to Thread
Results 1 to 2 of 2

DAX Measure - days lost to absence

  1. #1
    Registered User
    Join Date
    01-23-2020
    Location
    United Kingdom
    MS-Off Ver
    2016
    Posts
    37

    DAX Measure - days lost to absence

    Hi,

    I`m new to DAX and i`m struggling to add a measure. Essentially I have a list of absences for individual employees - please see the "Raw Data" tab. I`v added this to the data model and have created a Power Pivot table with absences summarised by type with days lost. What i would like a measure to do is show the amount of days lost per calendar month. The desired end result would be a chart with a slicer that would show days lost per absence type per month.

    Thanks in advance

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: DAX Measure - days lost to absence

    The desired end result would be a chart with a slicer that would show days lost per absence type per month.
    I am not sure why you would need to add a measure in order to accomplish this.
    Please take a look at the attached file and see if the pivot chart does what you want.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Count days falling within given period (with criteria)(absence tracker)
    By annazet in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2020, 05:04 AM
  2. Pivot Table: Grand Total different measure from Column measure
    By chinneywow in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-07-2019, 06:22 AM
  3. Counting the number of periods (not days) of absence in Excel
    By petedacreep in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-20-2016, 09:42 AM
  4. Calculate sick absence by days per month.
    By Pegs in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-10-2013, 06:57 AM
  5. [SOLVED] How to measure the time elapsed between two dates in hours - not days
    By lhbarnes2002 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-31-2012, 02:31 PM
  6. Replies: 2
    Last Post: 08-26-2011, 02:06 PM
  7. Replies: 7
    Last Post: 05-22-2006, 03:35 PM

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