Forum Discussion

mazzurri's avatar
mazzurri
Regular Visitor
6 years ago
Solved

DateDiff with SSAS Live Connection

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 M...
  • az38's avatar
    az38
    6 years ago

    mazzurri 

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

az38's avatar
az38
Community Champion
6 years ago

Hi mazzurri 

why dont you try a calculated column, not measure?

mazzurri's avatar
mazzurri
Regular Visitor
6 years ago

az38 

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

 

New Column Grayed Out

  • az38's avatar
    az38
    Community Champion
    6 years ago

    mazzurri 

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

    • mazzurri's avatar
      mazzurri
      Regular Visitor
      6 years ago

      az38 

       

      Thank you so much!

       

      Using the SELECTEDVALUE() I was able to do:

       

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