Reply
nabullock
Frequent Visitor

Issue using SELECTEDVALUE for selecting a specific date.

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

nabullock_0-1681143472821.png

But this to a column in table

nabullock_1-1681143572340.png

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

 

1 ACCEPTED SOLUTION
MohammadLoran25
Solution Sage
Solution Sage

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

 

 

 

View solution in original post

2 REPLIES 2
nabullock
Frequent Visitor

Thanks!

MohammadLoran25
Solution Sage
Solution Sage

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

 

 

 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)