Forum Discussion
AZJohnPowerBI
2 years agoHelper I
if statement isn't working
I have a lengthy if and statement for a slowly-changing dimension (SCD), as agents in my company come and go, and move around. I have tried each piece of the code separately, and it works, but wh...
AZJohnPowerBI
2 years agoHelper I
So the code is so long that it exceeds the maximum amount of chars haha, but I no longer think it's simply "the resulting value is outside the range", as that would mean the agent is outside the dates given. But I'm not sure how to move forward.