Hi @keith515,
Thanks for the reply from johnt75.
Could you please share a bit more about your .pbix file?
Based on your DAX, do you want to generate a new table(TB Report Tall) based on the Date column from DimDate table and some measures from your another fact table?
If so, it does cause a circle reference error when you want to create relationship between this new table(TB Report Tall) and DimDate table because the Date column you refer to in your new table(TB Report Tall) is actually from the DimDate table, which is undoable.
As a workaround, you could consider to use Power Query to union, Merge or Append, different method based on your need.
Merge queries overview - Power Query | Microsoft Learn
Append queries - Power Query | Microsoft Learn
Feel free to contact me if you have any problem.
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
