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

 Here am sending the data model and data per table ,Kindly find the attached file .    Its really apprieciate for your positive respones and your help.  Data Model Power BI Sample DataData ModelSample DataPower BI report

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Any inputs please 

  • 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.