Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 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...
Need Help
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-piga-msft

     

    Consider a table: Sales Order which has a Date (say) Shipment Date. I need to compare this column with Date table.

     

    For example: Date table consists a date 2/2/2018. So i should have a condition where Shipment Date < 2/2/2018. I will fetch the sum of quantities of every Shipment Date that will satisfy this condition

    .

    For example: The sum is 36 for 2/2/2018. So, the graph will contain 2/2/2018 on x-axis and 36 on y-axis.

     

    This will be considered for every Date in the Date table.

    So As per conditions applied it will display associated values with date.

     

     

     

     

     

     

     

     

    Thanks and regards,

    DAX_Learner