topic Issue using SELECTEDVALUE for selecting a specific date. in DAX Commands and Tips

Issue using SELECTEDVALUE for selecting a specific date.

nabullock — Mon, 10 Apr 2023 16:20:40 GMT

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

Re: Issue using SELECTEDVALUE for selecting a specific date.

MohammadLoran25 — Mon, 10 Apr 2023 17:06:37 GMT

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

Re: Issue using SELECTEDVALUE for selecting a specific date.

nabullock — Mon, 10 Apr 2023 21:29:10 GMT

Thanks!