datetable and fact table with multiple dates

[Arnoh]

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 the the the item has been resolved.

I want to create two different barcharts

1. with incomming new items each month
2. with resolved items each month.

I created one active relation between the fact table on creation date and date in the date table

Please help.

Thanx

[amitchandak]

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

[Arnoh]

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.