Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Help: what is the Dax code To use????

Hi Newbie here in Dax formula, 

 

what formula should i use if this is the outcome that i want to see ( expected Result, i want to get the oldest date). Thank you so much for the help

 

ProfileIdFinal Submission DateDistinctProfileDate expected Result
18747510/03/2023187475-3/10/2023 187475-3/10/2023
18747510/03/2023187475-3/10/2023 187475-3/10/2023
18747527/03/2023187475-3/27/2023 blank
18747527/03/2023187475-3/27/2023 blank
18747527/03/2023187475-3/27/2023 blank
18747501/04/2023187475-4/1/2023 blank
18747501/04/2023187475-4/1/2023 blank
18747501/04/2023187475-4/1/2023 blank
18747501/04/2023187475-4/1/2023 blank
18747501/04/2023187475-4/1/2023 blank
18747501/04/2023187475-4/1/2023 blank
18747501/04/2023187475-4/1/2023 blank
18747524/04/2023187475-4/24/2023 blank
18747524/04/2023187475-4/24/2023 blank
18747527/04/2023187475-4/27/2023 blank
18747527/04/2023187475-4/27/2023 blank
18747527/04/2023187475-4/27/2023 blank
18747528/03/2023187475-3/28/2023 blank
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    Anonymous As a column:

    expected Result column = 
  VAR __ProfileId = [ProfileId]
  VAR __MinDate = MINX(FILTER('Table', [ProfileId] = __ProfileId), [Final Submission Date])
  VAR __Result = MINX(FILTER('Table', [ProfileId] = __ProfileId && [Final Submission Date] = __MinDate), [DistinctProfileDate])
RETURN
  __Result
  • sevenhills's avatar
    sevenhills
    Super User
    3 years ago
    Exprected Column Result = 
IF ( 'Table'[ProfileId] = MIN('Table'[ProfileId]) 
          && 'Table'[Final Submission Date] = CALCULATE(Min('Table'[Final Submission Date]), Filter('Table', 'Table'[ProfileId] = MIN('Table'[ProfileId]) 
                                                                                                              && 'Table'[Final Submission Date] <= EARLIEST('Table'[Final Submission Date])))
   , 'Table'[DistinctProfileDate], blank()
)

    Column DAX code