cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JF_Rouanet New Member
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
Highlighted
Super User II
Super User II

Re: Cumulative value with Date table

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 🙂

Proud to be a Datanaut!

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors