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

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)