+ Reply to Thread
Results 1 to 1 of 1

DAX Calculate, in this case, orders placed and sent same period, month

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

    DAX Calculate, in this case, orders placed and sent same period, month

    I have attached a simple table showing what I'd like to achieve but without using the calculated column,

    essentially, I just used and if statement and then summed the result in a measure,


    Please Login or Register  to view this content.

    I'd like to do the whole thing in a measure , but it proved more tricky than I'd have thought, I've tried using datesbetween,

    Please Login or Register  to view this content.
    Any suggestions on best way to achieve this welcome,

    Richard.
    Attached Files Attached Files

+ 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. Calculate Income for each month based on commissions for a fixed period
    By JoelFrancis in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 03-15-2022, 04:28 AM
  2. Calculate Income for each month based on commissions for a fixed period
    By JoelFrancis in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-14-2022, 10:55 PM
  3. [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
  4. Replies: 1
    Last Post: 10-19-2018, 12:55 PM
  5. Calculate the number of working days month wise in a given period using VBA
    By rakesh3235 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 08-21-2014, 07:00 AM
  6. Replies: 10
    Last Post: 01-09-2014, 07:04 PM
  7. Replies: 2
    Last Post: 06-16-2012, 02:38 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