Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Relationship based on the multiple date columns

Hi ,   I have a date Dim and one customer fact table. And another Dim table called customer type.   In the Customer fact table I have a two different date columns. Let’s say 1) customer create da...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Here is the solution :

     

    Duplicated the table and made the relationship with date dim table.

     

    And in the dax function used below formula.

     

    IF (

        SELECTEDVALUE ( customer_type[cust-id] ) = 11

            && SELECTEDVALUE ( customer_type[cust-id]) = 10,

        [Enrolledvalue],

        [activevalues]

    )

     

    Enrolled values and active values are another dax function where I am calculating the KPI values.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Any one please suggest on this request .

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Here is the solution :

 

Duplicated the table and made the relationship with date dim table.

 

And in the dax function used below formula.

 

IF (

    SELECTEDVALUE ( customer_type[cust-id] ) = 11

        && SELECTEDVALUE ( customer_type[cust-id]) = 10,

    [Enrolledvalue],

    [activevalues]

)

 

Enrolled values and active values are another dax function where I am calculating the KPI values.