Forum Discussion
Adding a Calculated Table to Model
FreemanZ thanks so much. I will try. You see, I have calculated columns in each table and are needed in the summary and are lready being used in the existing measures and visulas. I suppose I can calculate these columns in power query, but I'm afraid that this exercise will baloon out of control. I was hoping if there was a way to somehow dodge that vexing circular reference.
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.
Hi, FreemanZ . Thanks for your help. I just thought I'd share with you that my suggested alternative last night (group by date) made no sense to me in the morning LOL, as it would present the same problem. So, what I am actually planning to do is to summarize everything that I need on that same page in the same table. This way I can use the week range filter from this summary table -- instead of the one from the calendar table. Thanks so much for your help.
Have you tried making a copy of your date table to use when creating your summarized table?
It might come down to how you created your date table. I'm not sure if this will work with a date table created in DAX but Power Query (or from source) should work.
Thanks grantsamborn . I did think about doing that this morning, but then, as you mentioned, it would probably not work if it is a DAX copy (will probably lead to circular reference again), and will further complicate my already crowded model. If I do it in power query, that will most likely work, but, again, there will be yet another table in the model. I will see if the self-sufficient dax table that I'm now creating will get the job done. If I hit a roadblock, I will then resort to creating another calendar (slimmed down) in power query. Thanks so much.
