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...
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 !

     

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