Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Comparing two date columns to get range of dates

Hi guys,

I am learning DAX  so need a help with below query.

 

I want to compare two date columns from two different tables,where after comparing it will display the dates like

"If values is less tan Current date it should display all those dates" and filter the data accordingly.

  In model all tables are connected using "Date" column and One to many relationship

 

Any help/Suggestion would be appreciated.

Need Help

4 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi Anonymous,

     

    I'm not very clear about what result you want to get. 

     

    If it is convenient, could you show some data sample and your desired output so that I can understand your scenairo better.

     

    In addition, you could have a reference of this similar thread.

     

    Best  Regards,

    Cherry

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I have below tables which are connected using Date column(One to many relationship)

      I want to compare Due date column from Gross table with CurrentDate column from GeneralDate table.

      As in where  [Due Date] >= Current date 

      Output: It should display all due date values which are  greater  than Due date 

       

      • v-piga-msft's avatar
        v-piga-msft
        Icon for Resident Rockstar rankResident Rockstar
        7 years ago

        Hi Anonymous,

        If it is convenient, could you share your data sample as table so that I can copy the data and make a test.

         

        In addition, your desired output want to show all due date values which are greater than Due date ?

         

        I'm still a little confused about your expected output, please share your the output so that I can understand your logic better.

         

        Best  Regards,

        Cherry