That's the odd one.
I have a virtual column calculating month's Status (Past, Current, Future). It's been (the Status column) there from the beginning and never caused any problems.
Recently I've been working on some calculations and from one thing to another I discovered that the table I am working from (let's call it Tag), is not reading this Status column correctly. By "not reading" I mean any Tag's column expression field. VC, Show, Require, etc.
Examples:
If I call Months[Status] from any other table, or automation it gives me a list of all Statuses in the Month table. It would be "Past, Past, Past, Current, Future, Future, Future" giving the Month table has 7 records.
But if I do it from Tag table, it always gives me "Past, Past, Past, Past, Past, Past, Past".
I checked every possible middle step. Tag reads all the other Month columns correctly (unless it's VC and its expression contains Status, then it uses the wrong value). No other table reads Status this way. Tag reads and calculates all parts of Status calculations correctly.
Has anyone dealt with a similar issue?
LinkedIn
Twitter
