Circular Dependency with calculated column making model relationship with different table

[Jnickson49]

Calculated Column in table to get cross over date 

trying to link to this table 

[PaulDBrown]

Try dragging the field from the bottom table (Category) to the calculated field you created. If that doesn't work, follow the recommendations from the gurus at sqlbi.com

https://youtu.be/m-qhcDcNKrE