Forum Discussion

nabullock's avatar
nabullock
Frequent Visitor
3 years ago
Solved

Issue using SELECTEDVALUE for selecting a specific date.

This code returns the correct value in a table "visual" 

But this to a column in table

sDate =
VAR selectedDate =SELECTEDVALUE(SelDates[ListedDate]) -30
Return selectedDate
 

 

  • MohammadLoran25's avatar
    MohammadLoran25
    3 years ago

    Hi nabullock ,

    You just need a CALCULATE:

    sDate =
VAR selectedDate =
    CALCULATE ( SELECTEDVALUE ( SelDates[ListedDate] ) ) - 30
RETURN
    selectedDate

     

    If this solves your question, Please give it a thumbs up and accept it as a solution to make it easier for the others to find what they are looking for.

    Regards,
    Loran

     

     

     

2 Replies

  • MohammadLoran25's avatar
    MohammadLoran25
    Solution Sage
    3 years ago

    Hi nabullock ,

    You just need a CALCULATE:

    sDate =
VAR selectedDate =
    CALCULATE ( SELECTEDVALUE ( SelDates[ListedDate] ) ) - 30
RETURN
    selectedDate

     

    If this solves your question, Please give it a thumbs up and accept it as a solution to make it easier for the others to find what they are looking for.

    Regards,
    Loran