+ Reply to Thread
Results 1 to 4 of 4

Dax to create measure to find Previous date to last cost by date.

  1. 03-16-2022, 07:29 AM #1
    Ramzan-ul-Mubarak
    Ramzan-ul-Mubarak is offline
    Registered User
    Join Date
    06-02-2017
    Location
    Lahore
    MS-Off Ver
    2010
    Posts
    22

    Post Dax to create measure to find Previous date to last cost by date.

    I need a dax for measure to find previous date cost to last cost by date.
    Sample file attached desired result shown in column F.
    Attached Files Attached Files
    Last edited by Ramzan-ul-Mubarak; 03-16-2022 at 07:33 AM.
    Reply With QuoteRegister To Reply
  2. 03-16-2022, 07:53 AM #2
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Dax to create measure to find Previous date to last cost by date.

    Hi again,

    Just duplicate the first formula I gave you but replace

    Query1[Date] <= ThisDate

    with

    Query1[Date] <= ThisDate - 1

    I don't understand your expected result for 01/02/2022, however: there is no day previous to that date.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    Reply With QuoteRegister To Reply
  3. 03-16-2022, 08:08 AM #3
    Ramzan-ul-Mubarak
    Ramzan-ul-Mubarak is offline
    Registered User
    Join Date
    06-02-2017
    Location
    Lahore
    MS-Off Ver
    2010
    Posts
    22

    Re: Dax to create measure to find Previous date to last cost by date.

    Thanks XOR LX.
    Problem solved.
    Sorry that was mistake by me. (expected result for 01/02/2022).
    Reply With QuoteRegister To Reply
  4. 03-16-2022, 08:10 AM #4
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Dax to create measure to find Previous date to last cost by date.

    You're welcome!

    Regards
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Problem in Dax to create measure to find last cost by date
    By Ramzan-ul-Mubarak in forum Excel General
    Replies: 3
    Last Post: 03-16-2022, 01:32 AM
  2. [SOLVED] FIND PRICE COST from MAX DATE based on ITEM ID and SALE DATE
    By aetedford in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-18-2018, 11:29 AM
  3. [SOLVED] Find the start date from end date and date range and exclude weekends
    By tantcu in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-28-2017, 04:43 AM
  4. [SOLVED] Find the Exact date, Nearest old and new date for the given input Letter) and date
    By thilag in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2015, 05:13 AM
  5. Hired Material Total Cost up to date based on returned quantity and date
    By [email protected] in forum Excel General
    Replies: 0
    Last Post: 01-28-2014, 07:37 AM
  6. Given an end date find corresponding start date 3 months prior ..quarter date range
    By welchs101 in forum Excel General
    Replies: 2
    Last Post: 01-04-2012, 09:15 AM
  7. [SOLVED] I need to measure hours between two events(time/date) to give me .
    By iartis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-11-2005, 10:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1