+ Reply to Thread
Results 1 to 1 of 1

Problem in Dax to create measure to find Previous date Latest Cost.

  1. #1
    Registered User
    Join Date
    06-02-2017
    Location
    Lahore
    MS-Off Ver
    2010
    Posts
    22

    Cool Problem in Dax to create measure to find Previous date Latest Cost.

    Dax measure to find previous day latest cost is working if all dates are selected in pivot table. But if all dates are not selected then previous day latest cost is not found although it exists in source data.
    Help needed on it.
    Result is needed in Column F in attachment. Desired result is shown in G Column in attachment.

    I have posted the problem at an other forum too. Link is given below.

    https://www.excelguru.ca/forums/show...7495#post47495
    Attached Files Attached Files
    Last edited by Ramzan-ul-Mubarak; 03-21-2022 at 04:00 AM.

+ 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] Dax to create measure to find Previous date to last cost by date.
    By Ramzan-ul-Mubarak in forum Excel General
    Replies: 3
    Last Post: 03-16-2022, 08:10 AM
  2. [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
  3. [SOLVED] previous month last existing date based on latest date
    By rachelwahid in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-03-2021, 02:42 AM
  4. [SOLVED] Calculate to the latest date & ignore the previous
    By chaiyya345 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-21-2020, 02:15 AM
  5. Replies: 5
    Last Post: 11-25-2019, 03:46 AM
  6. Replies: 9
    Last Post: 12-21-2014, 06:29 PM
  7. Replies: 1
    Last Post: 06-01-2014, 09:56 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1