Forum Discussion

ItSupportElm's avatar
ItSupportElm
Helper III
6 years ago
Solved

Power Query to DAX

Hello,

 

Im not confortable with DAX , someone can tell me how to translate this : " if Date.From([DateCreation]) > Date.From(Date.AddDays(DateTime.LocalNow(),-2)) then 0 else 1)" to DAX please ? i tried so many thing but it didnt worked.

 

Thanks for the future answer, great day

Need Help
Tips and Tricks
  • dax's avatar
    dax
    6 years ago

    Hi ItSupportElm,

    You could follow above suggestions. If you want to create calculated column, you could try below expression 

    Column = if('Table'[date]>TODAY()-2,0,1)

    If you want to use measure, you could try below expression

    Measure 2 = if(MIN('Table'[date])>TODAY()-2,0,1)

     

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • ItSupportElm's avatar
    ItSupportElm
    6 years ago

    Thanks for the answer guys.

     

    dax i tried your expression but there is an error at the end :   ( i thought that was ";" but is not that neither)

     

    Same for a new colomn : 

     

    Thanks again for helping me

     

     

    I found out why it not work, 

     

    Column = IF('Alerte'[DateCreation]>TODAY()-2;"Inférieur à 48H";"Supérieur à 48H") we must seprate with ";" 
    Thanks again !

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    It would be something like this. Assuming you`re adding a calculated columns and not creating a measure.

     

    In the table you want to add the column, create a new calculated column and type this.

     

    if ( TableName[Date Field] > DATEADD ( TODAY(); -2; Days) ; 0 ; 1)

     

    You may need to adjust some naming but the overall idea is this.

     

    Hope it helps

     

     

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi ItSupportElm,

    You could follow above suggestions. If you want to create calculated column, you could try below expression 

    Column = if('Table'[date]>TODAY()-2,0,1)

    If you want to use measure, you could try below expression

    Measure 2 = if(MIN('Table'[date])>TODAY()-2,0,1)

     

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • ItSupportElm's avatar
      ItSupportElm
      Helper III
      6 years ago

      Thanks for the answer guys.

       

      dax i tried your expression but there is an error at the end :   ( i thought that was ";" but is not that neither)

       

      Same for a new colomn : 

       

      Thanks again for helping me

       

       

      I found out why it not work, 

       

      Column = IF('Alerte'[DateCreation]>TODAY()-2;"Inférieur à 48H";"Supérieur à 48H") we must seprate with ";" 
      Thanks again !