topic Re: datediff dax -formula in DAX Commands and Tips

datediff dax -formula

jj1 — Fri, 23 Aug 2024 22:33:11 GMT

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?

Re: datediff dax -formula

lbendlin — Fri, 23 Aug 2024 22:49:55 GMT

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

Re: datediff dax -formula

jj1 — Fri, 23 Aug 2024 23:13:51 GMT

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

Re: datediff dax -formula

lbendlin — Fri, 23 Aug 2024 23:19:06 GMT

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-Forum/ba-p/963216

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/1447523

Re: datediff dax -formula

jj1 — Fri, 23 Aug 2024 23:22:13 GMT

Re: datediff dax -formula

jj1 — Fri, 23 Aug 2024 23:23:15 GMT

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

Re: datediff dax -formula

jj1 — Fri, 23 Aug 2024 23:28:23 GMT

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

Re: datediff dax -formula

lbendlin — Fri, 23 Aug 2024 23:37:51 GMT

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

Re: datediff dax -formula

jj1 — Sat, 24 Aug 2024 16:28:50 GMT

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

Re: datediff dax -formula

jj1 — Sat, 24 Aug 2024 16:30:40 GMT

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

Re: datediff dax -formula

jj1 — Sat, 24 Aug 2024 16:32:37 GMT

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

Re: datediff dax -formula

lbendlin — Sat, 24 Aug 2024 21:38:41 GMT

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

Re: datediff dax -formula

jj1 — Sun, 25 Aug 2024 00:45:13 GMT

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?

Re: datediff dax -formula

lbendlin — Sun, 25 Aug 2024 00:53:45 GMT

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.

Re: datediff dax -formula

jj1 — Sun, 25 Aug 2024 05:20:52 GMT

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