Forum Discussion

rakary_10's avatar
rakary_10
Regular Visitor
3 years ago
Solved

Dax date before today

Hi could you please help me? Availability = IF ('Supply T&O dec 8th'[FAD] .[Date] <= TODAY(),"Now Available",IF('Supply T&O dec 8th'[FAD] .[Date] >= TODAY() + 30, "Coming Available", "Not available"...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    Try this calculated column formula

    Availability = IF('Supply T&O dec 8th'[FAD]<= TODAY(),"Now Available",IF('Supply T&O dec 8th'[FAD]>=TODAY()+30,"Coming Available","Not available"))
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Try this calculated column formula

Availability = IF('Supply T&O dec 8th'[FAD]<= TODAY(),"Now Available",IF('Supply T&O dec 8th'[FAD]>=TODAY()+30,"Coming Available","Not available"))