topic Re: DateDiff with SSAS Live Connection in DAX Commands and Tips

DateDiff with SSAS Live Connection

mazzurri — Tue, 10 Mar 2020 14:53:54 GMT

I would like to filter my table by line items greater than 5 days old. I would need to take State_Created_Date and subtract it from the Current_Time (both are date/time fields) . When I try to do a Measure it doesn't let me select any of those dates in my formula.

Re: DateDiff with SSAS Live Connection

az38 — Tue, 10 Mar 2020 19:34:38 GMT

Hi mazzurri

why dont you try a calculated column, not measure?

Re: DateDiff with SSAS Live Connection

mazzurri — Tue, 10 Mar 2020 19:37:29 GMT

az38

I am unable to make a column since it is a live connection. New Column is grayed out.

Re: DateDiff with SSAS Live Connection

az38 — Tue, 10 Mar 2020 19:39:21 GMT

mazzurri

try to use SELECTEDVALUE() over column name in measure, like SELECTEDVALUE([State_Created_Date])

Re: DateDiff with SSAS Live Connection

mazzurri — Tue, 10 Mar 2020 19:53:34 GMT

az38

Thank you so much!

Using the SELECTEDVALUE() I was able to do:

Datediff = DATEDIFF(SELECTEDVALUE([State_Created_Date]), SELECTEDVALUE([Current_Time]),DAY)