Forum Discussion
datetable and fact table with multiple dates
Hello, I have a fact table with multiple dates and one date table witch contains year and month etc. In the fact table i have an date witch contains the creationdate and a date witch contains...
There are two ways. You can create one more relation between two tables. With another date in fact. That will be inactive. And In case you need another date. In your calculate formula you can activate another date. using userealtion.
In case there are too many measures on both dates. You can create one more copy of the date table and join with another date.
Date2 = date
Hi Thanx, for your information.
Can you tell me how the dax formula looks like when i want to retrieve the month for the inactive relationship date field?
Thank you.