Dates in Between Format

[nataliesmiy1357]

Hello!!  I am trying to calculate a BUNCH of dates in the time period measures, but none of them are seeming to actually code.  When I type in the columns in the dax, they won't pop up.  What is the format of the value that I need to have for those dates?  Currently they are date/time and on one of the common formats.  

Thanks in advance.

[PhilipTreacy · Accepted solution]

Hi @nataliesmiy1357 

You need to use SELECTEDVALUE so DATEDIFF knows which dates to use

Measure = DATEDIFF(SELECTEDVALUE('DataTable'[CreateActivityPlanStartDate]), SELECTEDVALUE('DataTable'[CreateActivityPlanEndDate]), DAY)

Regards

Phil

[v-henryk-mstf · Accepted solution]

Hi @nataliesmiy1357 ，

According to my tests, both of the following ways can get the date difference between the start date and the end date.

M_1 = DATEDIFF(MAX('Table'[Start Date]),MAX('Table'[End Date]),DAY)

M_2 = 
var a = SELECTEDVALUE('Table'[Start Date])
var b = SELECTEDVALUE('Table'[End Date])
return
CALCULATE(DATEDIFF(a,b,DAY),ALL('Table'))

If the understanding is wrong, are you able to point out the problem and provide the desired result. Looking forward to your feedback.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PhilipTreacy · Accepted solution]

Hi @nataliesmiy1357 

You need to use SELECTEDVALUE so DATEDIFF knows which dates to use

Measure = DATEDIFF(SELECTEDVALUE('DataTable'[CreateActivityPlanStartDate]), SELECTEDVALUE('DataTable'[CreateActivityPlanEndDate]), DAY)

Regards

Phil

[PhilipTreacy]

Hi @nataliesmiy1357 

Need more information please, and maybe screenshots to se what you are doing.

If you are typing a DAX function name it should prompt you with what parameters (e.g. tables, columns) it can use.  If it isn't then I suspect you're using the wrong function at that time, or the function can't 'see' the column/table.

The format and data type of the column doesn't mnatter to the DAX function as you type, it only checks this when it tries to calculate.

Please supply data, screenshots and a detailed explanation of what you are trying to do.

Regards

Phil

[nataliesmiy1357]

Phil - This is a screenshot of my data.  So what I want to do, is do how many days in between the EndDate and the StartDate.  But when I do the DAX Difference = Datediff(......) the columns don't populate.