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
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.
