topic Re: How to Use a What If Date Parameter in DAX Commands and Tips

How to Use a What If Date Parameter

daniel_epc — Fri, 27 Jan 2023 19:28:08 GMT

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

Re: How to Use a What If Date Parameter

amitchandak — Sat, 28 Jan 2023 02:40:09 GMT

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)

Re: How to Use a What If Date Parameter

daniel_epc — Sat, 28 Jan 2023 18:40:00 GMT

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?

Re: How to Use a What If Date Parameter

daniel_epc — Sun, 29 Jan 2023 17:49:47 GMT

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,