date Measure error

[Anonymous]

Hi Experts

Cannot see the error in the following measire 

days = IF( DATEDIFF(SELECTEDVALUE('Table'[Ticket date]),TODAY(), DAY) < 30,1, IF( DATEDIFF(SELECTEDVALUE('Table'[Ticket date]),TODAY(), DAY) >0 && <=30,2,3)))

[jppv20]

@Anonymous 

Can you give some example data from your table(s)?

[jppv20 · Accepted solution]

Hi @Anonymous ,

Try this:

days = IF( DATEDIFF(SELECTEDVALUE('Table'[Ticket date]),TODAY(), DAY) < 30,1, IF( DATEDIFF(SELECTEDVALUE('Table'[Ticket date]),TODAY(), DAY) >0 && DATEDIFF(SELECTEDVALUE('Table'[Ticket date]),TODAY(), DAY) <=30,2,3))

If I answered your question, please mark it as a solution to help other members find it more quickly.

[Anonymous]

jppv20, hw would you write the above with out selected value and as a calculated column?