Forum Discussion

daniel_epc's avatar
daniel_epc
New Member
3 years ago

How to Use a What If Date Parameter

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

 

What If Date

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    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's avatar
      daniel_epc
      New Member
      3 years ago

      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,

  • daniel_epc's avatar
    daniel_epc
    New Member
    3 years ago

    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?