Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Multiple dates in one table vs Date Table

Hi All, 

 

I have created a DATE table for my powerBi reports. I have another table where I have Create_date and Close_date. I create relationship with Date table to my Close_date and wanted to see the revenue. It worked. However, it seems you can only use 1 active relationship. 

 

I have added another relationship with Create_date to date table but it can't be active. I want to see the revenue by create date using date table. I have tried multiple ways using DAX function. 

 

Here is the link to the same issue  - https://community.powerbi.com/t5/Desktop/USERELATIONSHIP-to-work-with-multiple-dates/m-p/552178#M259882

CALCULATE (
    SUM ( Opportunity[actualvalue_base] );
    USERELATIONSHIP (
        Opportunity[Created On];
        'Date'[Date]
        )
)

I did use the same and changed the create_date to date format however my data is not showing for all the date and just showing till Jan 2021 and also the values aren't correct for the weeks it is showing. 


P.s. My values are shwoing correct for close_date. May be because it is active relationship. 


Can any one help me to achieve this please? 

 

Thanks,
Sapna

 

 

2 Replies