How to Use a What If Date Parameter

[daniel_epc]

Hi All,

Maybe it is a silly question, but I am not able to use a What If Date parameter in a DAX Measure, what I need is to calculate the days between the date parameter and another date field.

The parameter shows up correctly if I put it directly on the table, but when I try to access its value via DAX it retrieves the Minimum Date of the parameter range, the function SELECTEDVALUE doesn't retrieve any value.

Thanks in advance for your help,

Daniel

[daniel_epc]

Thanks @amitchandak, but it is still not working, the parameter and the dax measure have the same code but the last one doesn't evaluate as desired.

Parametro Fecha Value = MINX(ALLSELECTED('Parametro Fecha'[Parametro Fecha]),'Parametro Fecha'[Parametro Fecha])

DiasEnInventario = MINX(ALLSELECTED('Parametro Fecha'[Parametro Fecha]),'Parametro Fecha'[Parametro Fecha])

Can you help me to understand what am I missing?

[amitchandak]

@daniel_epc , I am assuming the date parameter table is not joined to another table

You can get min/ max date like this 

//Date1 is an independent Date table and Date is Joined
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])
return

Averagex(Table, Datediff(Table[Date], _max, Day)

[daniel_epc]

Thanks @amitchandak , but I still couldn't get it to work, the parameter and the dax measure have the same code but the last one doesn't evaluate as desired.

Parametro Fecha Value = MINX(ALLSELECTED('Parametro Fecha'[Parametro Fecha]),'Parametro Fecha'[Parametro Fecha])

DiasEnInventario = MINX(ALLSELECTED('Parametro Fecha'[Parametro Fecha]),'Parametro Fecha'[Parametro Fecha])

The date parameter is not joined to any table, should it be?

Thanks in advance,