Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

If statement for a calculated column

Hi,   I have a column added into my table which is using a datediff that says how many days between 2 dates , Age =datediff('Table1'[Date A],'Table 1'[Date 2],DAY)   However I am trying to creat...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    if you use DAX calculated column your new column will look like

    Test = MIN([Age], 7)

    you also can use this technique

    Age = 
var _dd = datediff('Table1'[Date A],'Table 1'[Date 2],DAY)
RETURN 
IF(_dd < 7, 7, _dd)

      

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , for one, is DAX, the second one is M?

Try

Age =
var _1 = datediff('Table1'[Date A],'Table 1'[Date 2],DAY)
return
if(_1>7,7,_1)