Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Comparing two columns- if single date value is in two weeks in all another column values

Hello everyone,   I'm new to DAX syntax. Couldn't figure this out. Looks easy but challenging. Here is the situation: Comparing two date column. If a single [created_date] column value is in the l...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi  Anonymous ,

     

    First create a column as below:

    last date = 'Table'[appointment_date]-14

    Then create a dim table:

    dim = ADDCOLUMNS(SELECTCOLUMNS('Table',"start date",'Table'[last date],"end date",'Table'[appointment_date]),"key",1)

    Finally create a column as below:

    dim = ADDCOLUMNS(SELECTCOLUMNS('Table',"start date",'Table'[last date],"end date",'Table'[appointment_date]),"key",1)

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous Try:

 

Column =
  VAR __Date = [created_date]
  VAR __Appointments =
    ADDCOLUMNS(
      ALL('Table'[appointment_date]),
      "__diff",([appointment_date] - [created_date]) * 1.
    )
RETURN
  IF(MINX(__Appointments,[__diff])<15 && MINX(__Appointments,[__diff])>-15,"Yes","No")