Forum Discussion
Adding a Calculated Table to Model
hi yasbos
i see . indeed considerable sunk cost. you may also try combine columns from both sides and relate on the combined coulmn.
In the long term, for cases like this, i would insist to suggest appending tables in PQ.
Thanks, FreemanZ . Please, elaborate on the suggested solution. I didn't quite get it. I need to link back to the calendar table using the week range that is in the calculated table (summarizecolumns) which itself (week range) comes from the calendar table -- oh my, just saying that made me not blame power bi for not allowing it. It's a clear circular reference. Oh, well. Ok, I will try tomorrow morning to use the date column of the calendar table in the summarizecolumns instead of using the week range column. I hope that then when I use the week range column in the visual, the metrics will be summarized at the week range, and, at the same time, it will allow me to use the week range in the model relationship.