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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
JF_Rouanet
New Member

Cumulative value with Date table

Hello to everyone,

 

first of all i am a newb

i have 2 tables :

1 - drawings list with release date given by the consultant.

2 - drawings list export from our CDE (or electronics data base of drawings available for everyone on site). This table containes date of the release of the drawings.

 

As i need to create 2 Scurve (table 1 vs table 2) i created a date table and create a relationshio between Date_table and table 1 and Date_table and table 2.

I created in table 1 and 2 a measure of cumulative count of drawings which works fine. Graphics is a perfect s curve.

But as soon as i tried to combine all in one graphics, the cumulative measure doesn't work, instead of counting, it just shows the value at the dedicated date.

I think it's a basic mistake for you but i would really appreciate your help.

Thank you very much

Jeff

2019-10-07_19h42_40.png

 

2019-10-07_19h43_51.png

 

1 REPLY 1
Stachu
Community Champion
Community Champion

try switching the bidirectional relationships to single and make sure the months in the charts are coming from the DATE_TABLE



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors