Get seleted date in slicer on column

[luis951225]

good afternoon

I need in a column or measure, calculate the difference of days between the selected dates in the slicer ... some function?

I speak Spanish.

the image in the link

https://www.dropbox.com/s/pe0hen9ghx65r8d/Captura12.PNG?dl=0

[v-caliao-msft]

@luis951225,

We can use DAX below to achieve this requirement.

days =
VAR selecteddate =
    IF ( ISFILTERED ( 'Table'[Date] ), MAX ( 'Table'[Date] ), BLANK () )
RETURN
    1
        * ( MAX ( Table1[Date] ) - selecteddate )

Regards,

Charlie Liao

[luis951225]

hi

my problem is

I need to obtain the two date values ​​selected by the user and calculate the difference of days.

the values ​​that I want to calculate must be taken from the slicer or filter and then used in a column in the table

 new column o measure = Date selected "30" - "03" = "27" days

My skipe is luis951225@hotmail.com

Thanks