Forum Discussion
Days DAX as Calculated Column with out using Selected Value
Hi Experts
how would you write the following as a calculated column and not as a measure, there is a error in my dax
days = IF( DATEDIFF('Table'[Ticket date]),TODAY(), DAY) < 30,1, IF( DATEDIFF('Table'[Ticket date]),TODAY(), DAY) >0 && DATEDIFF('Table'[Ticket date]),TODAY(), DAY) <=30,2,3))
Anonymous , Try like
days = Switch(True(),
DATEDIFF('Table'[Ticket date],TODAY(), DAY) < 30,1,
DATEDIFF('Table'[Ticket date],TODAY(), DAY) > 0 && DATEDIFF('Table'[Ticket date],TODAY(), DAY) <=30,2
,3)
2 Replies
- amitchandak
Super User
Anonymous , Try like
days = Switch(True(),
DATEDIFF('Table'[Ticket date],TODAY(), DAY) < 30,1,
DATEDIFF('Table'[Ticket date],TODAY(), DAY) > 0 && DATEDIFF('Table'[Ticket date],TODAY(), DAY) <=30,2
,3)