Forum Discussion
Using slicer to get date and put into column
Hi, I want to use the slicer input to get the value (date) and substract the date with the other date in the other table. I already create a measure with this DAX, DateSelected = SELECTEDVALUE(Da...
Calculated columns are calculated once - on load. So SELECTEDVALUE will never be valid, and the column will not react to any changes you make in the report.
Instead, create another measure akin to
Days = SELECTEDVALUE(DateInput[DateInput]) - SELECTEDVALUE(INVENTBATCH[XFSRECEIVEDATE])and add the measure to the table or matrix where you want the value to appear. As long as rows are not summarized (so XFSRECEIVEDATE only has one value in a row), it should work. You may want to add ISBLANK tests or alternate values in the second argument to SELECTEDVALUE in order to handle cases where values are not scalar
amitchandak
Super User
Super UserTry
Days =
VAR selected = SELECTEDVALUE(DateInput[DateInput])
return
datediff(selected,max([XFSRECEIVEDATE].[Date]),day)
//////////////////OR
Days =
VAR selected = maxx(SELECTEDVALUE(DateInput),DateInput[DateInput])
return
datediff(selected,max([XFSRECEIVEDATE].[Date]),day)Hi amitchandak ,
You can try to look at the comment that i mentioned hansei where the result that I exactly want. I want the result by row and not a single result. Thank you.
