Custom Date Column

[ArchStanton]

Hi

Earlier today I created a Custom Column in my data model that produced dates on a series of expressions using the SWITCH function because the IF statement was just too long and complicated to decipher.

I do have a separate Date table in my data model - would it be best practice to create a relationship between the two? I'm guessing yes. I just want to be 100% sure thats all so to not experience a issues down the line.

Thanks,

[ArchStanton · Accepted solution]

Thanks for the reply, I've managed to figure this one out myself!

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?