Forum Discussion

Nihonadmin's avatar
Nihonadmin
New Member
7 years ago
Solved

dax if condition for date

Hi Everyone,

 

Please anyone help me in  dax if condition 

 

1. IF ( Plannedenddate > Actualenddate then "Delayed" )

 

 

Thank You

Tips and Tricks

3 Replies

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User
    7 years ago

    IF ( Actualenddate>Plannedenddate,"Delayed")

  • pallavinegi's avatar
    pallavinegi
    Frequent Visitor
    3 years ago

    Hi, thanks for the answer. 

    Actually, here is the condition which I want to apply, but could not achieve the result. I want to see the average for the date (today's date-7).

    Sheet1'[Sale Order Date].[Date]= today()-7
    Thanks in advance!