Forum Discussion
Dates to another table
Hi, hope someone will help me How do I get dates from main table to sales table? There is relationship betweent these two tables on Order column, orders can repeat in main table. I need to have ...
You should be able to use RELATED(DimDate[Date]) or month, week, etc to get whatever info you need into the Orders table. This is only necessary if doing a Column or row context measure. Otherwise, the relationship should work as long as it is ACTIVE?
I want a column. Relationship is active, many to many. That was first thing I tried, doesnt work. It is telling me this:
The column 'SSBI[TRIPNAME]' either doesn't exist or doesn't have a relationship to any table available in the current context.