Forum Discussion
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"...
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"))
Availabitity =
VAR __count1 = COUNTROWS(FILTER('Supply T&O dec 8th', 'Supply T&O dec 8th'[FAD] <= TODAY))
VAR __count2 = COUNTROWS(FILTER('Supply T&O dec 8th', 'Supply T&O dec 8th'[FAD] <= (TODAY + 15)))
VAR __result = IF (__count1 >=1,
"Available",
IF (__count2 >= 1,
"Coming available",
"Not available"
)
)
RETURN
__result
It doesn't work when I create a column
