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 Measure it doesn't let me select any of those dates in my formula. 

 

  • az38's avatar
    az38
    6 years ago

    mazzurri 

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

4 Replies

    • 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])