Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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#M259...

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 2
amitchandak
Super User
Super User

@Anonymous , check there is no timestamp in created on. You change data type to timestamp and have format to show time and check it

 

You can create date if need

created date = datevalue([Created on])

 

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4

measure using  Userelation will also filter on the same selected date

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

@amitchandak  - Checked, not working. See the screenshots below - 

 

Screen Shot 2022-03-16 at 10.31.20 AM.pngScreen Shot 2022-03-16 at 10.30.24 AM.png

 

My CreatePipe numbers are in millions. 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.