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.
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.
