datediff dax -formula

[jj1]

hi im trying to use a simple datediff dax formula to obtain the sla difference in terms of calendar days between two date columns in the table- it should be very easy but when i selectthe datediff function-it is not giving the option to select the table from the query for th two date columns) normally any dax formula new calculation allows that . any ideas why it wont allow or show the selection as i type the datediff formula? 

[jj1]

so as i write the dax formula-it is not allowing me to select the activitypointer query and select the tables to calculate) normally dax formulas always allow this for me or anyone

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

[jj1]

so the report view is not giving the minute or hour maybe i need to add a new field idk? but the table view is giving that and i think that is why datediff wont recognize the table inthe query or allow me to select it

[jj1]

 

[jj1]

the issue is in the table the date is listed as long form month day and hour and minute but when i move to the report it gives me in the date table only month and day and year and quarter so i guess since the report is not showing the hour and minute as in the table then it wont activate the normal datediff identifier 

[lbendlin]

That's not the reason.  Look at the DAX code before that spot.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[jj1]

Created Date Month	Created Date Day	Reply Date Month	Reply Date Day
Jan	20	Jan	22
April	21	April	25

[jj1]

Create Date	Reply date
1/2/24 905am	1/5/24 912pm

[jj1]

so when i use sla-datediff- it is not recognizing the columns and so instead of offering me the selection to click the table in the query to enter values for sal dax date difference instead it does nothing- same if i use datesbetween dax etc or bus day sla

[lbendlin]

Datediff requires scalar attributes. You cannot use it with columns.

[jj1]

oh i see tha texplains it-dax formual DateDiff is not able to leverage columns data-ok so what is simplest way to do the dax calculcation within the query or table to establish bus day or claendar day sla between the two date columns? 

[lbendlin]

change your calculation to a calculated column (since the data is likely immutable)  or if you need to use a measure then aggregate the data somehow, with SELECTEDVALUE or equivalent.

[jj1 · Accepted solution]

this is sovled-rather than using a new measure in the report view- i used dax datediff in the data(table view) and datediff works just fine to get sla from one date compared to another (calendar days for this purpose) and can be set for hours or weeks or days-i chose days and sla achieved via dax date diff after all--closing this one as solved- thanks all

[lbendlin]

It will not show the Intellisense hints if you have an error in a previous part of your formula.