+ Reply to Thread
Results 1 to 2 of 2

DAX TOTALMTD function and advice on using it.

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

    DAX TOTALMTD function and advice on using it.

    Hi,
    Can some one help or point me in the direction of information on TOTALMTD,

    As far as I can gather the syntax is

    Please Login or Register  to view this content.

    First does the date in the Totalmtd come from the 'sales' table or the CALENDAR table ? I've tried both and neither worked.
    I've attached a two column table with some dates and figures, any help welcome as I seem to be misunderstanding
    the basics.

    update post

    After a bit more experimenting I've found that

    Please Login or Register  to view this content.
    does work, but I still don't understand TOTALMTD so still need some help.

    Richard.
    Attached Files Attached Files
    Last edited by Dicken; 07-06-2022 at 09:50 AM. Reason: More information

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

    Re: DAX TOTALMTD function and advice on using it.

    I seem to have been confusing the syntax for
    DATESMTD and TOTALMTD

    the correct syntax for DATE is

    MTD:=CALCULATE([tSales],DATESMTD(Table2[Date]) )
    or more fully;

    MTD :=
    CALCULATE (
    [tSales],
    DATESMTD ( CALCULATETABLE ( DISTINCT ( Table2[Date] ) ) )
    )
    And for TOTALMTD

    new:=TOTALMTD([tSales],Table2[Date])

    I don't know if this is a short 'sugar' for something more complex.

    Richard

+ 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. Advice with LOOKUP function
    By mchlbrmn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-12-2020, 05:17 PM
  2. [SOLVED] Month Function advice
    By lordfa9 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2015, 01:49 AM
  3. VBA code advice/Excel advice for summing groups of numbers
    By paulblower in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-17-2014, 05:47 AM
  4. IF function advice needed
    By mairead100 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-12-2014, 06:59 AM
  5. Advice on simplifying this function
    By mcrae in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2014, 08:56 AM
  6. [SOLVED] IF Function advice or other solutions
    By Johnie5 in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 07-19-2012, 04:57 PM
  7. Advice required for this function
    By localhost in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-05-2008, 06:04 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