+ Reply to Thread
Results 1 to 3 of 3

DAX calculate Total between two dates and only show for that period

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    613

    DAX calculate Total between two dates and only show for that period

    Hi,
    is there a way to use dates beteen, to get the total between two dates and then only show for that perid,
    so

    Please Login or Register  to view this content.
    But this would show for every date in a pivot or matrix, so I put keep filters

    Please Login or Register  to view this content.
    Which restricts it to the relevant period but also filters down the value to the amount for that period, I'm trying for a mix of the two
    so in a pivot of Jan to Dec, Total for eg March - June which only appears for the Month Marth to June?

    All I can think is to use an IF statement, is there another / better way of achieving this?

    One other point in above I've used MAX to get the start end dates, is that a 'good' way or should I be using something else.

    Richard , I've attached the above.
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: DAX calculate Total between two dates and only show for that period

    Quote Originally Posted by Dicken View Post
    All I can think is to use an IF statement, is there another / better way of achieving this?
    What qualifies as "better"?
    Rory

  3. #3
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    613

    Re: DAX calculate Total between two dates and only show for that period

    Don't know really just thought their might be other approaches.

+ 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. Excel formula to calculate period in months and days between two dates
    By sunboy in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-18-2023, 06:41 AM
  2. [SOLVED] Calculate # working days (by month) in a period of time to show in pivot table
    By TryingToLearnUK in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-06-2020, 03:39 PM
  3. [SOLVED] Calculate total hours that fall between a specific date / time period (Over midnight)
    By nik_re in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-21-2020, 09:05 AM
  4. [SOLVED] Calculate total hours that fall between a specific time period (Over midnight)
    By nik_re in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-20-2020, 09:06 AM
  5. [SOLVED] Formula Needed - Calculate total hours that fall between a specific time period.
    By JennyGP in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 04-19-2020, 02:44 AM
  6. [SOLVED] Using the Count functin to calculate dates between a specific time period
    By micjoy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-15-2017, 05:02 PM
  7. Calculate period between multiple dates _VBA script
    By raw_geek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-07-2014, 08:03 AM

Tags for this Thread

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