Forum Discussion
Arnoh
Helper III
Helper IIIdatetable 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...
amitchandak
Super User
Super UserThere 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
ArnohHelper III
Helper IIIHi 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.