Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Day Count between two dates - DAX Help

I have seen a number of posts about calculating the day count between two date.  None seem to address my specific use case.   I am tring to calculate the day count between a "Creation Date" and "St...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Anonymous,

     

    If you can't ensure which date column with be the small one, you should add some operation to get the specificity one.

     

    As I write above, min and max function can used to auto return the matched date.

     

    I build a sample table with random date store in date1 and date2, then I can use above formula to get the diff between these date column.

     

    Table formula:

    Sample = ADDCOLUMNS(GENERATESERIES(1,100,1),"Date1",RANDBETWEEN(DATE(2015,1,1),TODAY()),"Date2",RANDBETWEEN(DATE(2015,1,1),TODAY()))

     

    Calculate column:

    Diff = DATEDIFF(MIN([Date1],[Date2]),MAX([Date1],[Date2]),DAY)

     

     

    Reuslt:

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

CanadaMGB

 

Thanks for the feedback, though I am not sure this is a solution.  Based on the instructions it appears the solution you posted is giving me a day count between today and the Start Date.

 

In my use case, I need to simply calc the day count between two specific columns.

CanadaMGB's avatar
CanadaMGB
Frequent Visitor
8 years ago

What its doing is exploiting the aging function in a different way, taking the difference between today and both the start and end dates individually, which when subtracted gives you a numerical difference you can work with. See image below, I made a copy of the original start and end date columns and aged them per the instructions. The difference is the days between them.