+ Reply to Thread
Results 1 to 1 of 1

Problem Using Previous Month and Calculate in DAX

  1. #1
    Registered User
    Join Date
    06-29-2017
    Location
    Los Angeles, CA
    MS-Off Ver
    2010
    Posts
    43

    Problem Using Previous Month and Calculate in DAX

    Hi,

    I'm relatively new to DAX, but I'm just trying to put together a simple measure that takes the month-end inventory for a bunch of part numbers and sets it equal to the next month's beginning inventory. The month-end inventory is data in a data table. I have set up a couple measures that are meant to use the starting inventory, but since I can't get the starting inventory to work, none of my other measures are giving me correct numbers. In my attached file, I'm not getting an error for the starting inventory measure, but it's also not returning any values (see Sheet 1). Any help is appreciated!
    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. [SOLVED] Dynamic formula to calculate the difference between current and previous month
    By kay007 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-19-2015, 11:19 AM
  2. Macro using vlookups comparing 2 months paysheet(previous month and current month)
    By srinivasan1965 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2012, 03:45 AM
  3. [SOLVED] VBA to identify the current month and previous month based on system date
    By ravikumar00008 in forum Excel General
    Replies: 10
    Last Post: 07-26-2012, 10:04 AM
  4. Replies: 4
    Last Post: 03-19-2012, 08:58 AM
  5. formula to calculate "previous month"
    By Gti182 in forum Excel General
    Replies: 5
    Last Post: 11-15-2010, 05:49 AM
  6. Replies: 4
    Last Post: 08-26-2010, 07:32 AM
  7. Auto calculate end date of previous month
    By BusterBoy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-28-2009, 07:57 PM

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