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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

TWO CUMULATIVES IN THE SAME GRAPH

Hi everyone!

 

I need to have two cumulatives in the same graph

 

I created these measures: 

 

1) 

Msr Cumulative Creation Date = CALCULATE(
COUNT ('PLM Parts Last'[WT Part Number]);
FILTER(
ALL('PLM Parts Last'[Date Creation Min]);
'PLM Parts Last'[Date Creation Min] <= MAX('PLM Parts Last'[Date Creation Min])
)
)

 

2)

Msr Cumulative Date Modif. = CALCULATE(
COUNT ('PLM Parts Last'[WT Part Number]);
FILTER(
ALL('PLM Parts Last'[Date Modif.]);
'PLM Parts Last'[Date Modif.] <= MAX('PLM Parts Last'[Date Modif.])
)
)
 
thank you all!
1 REPLY 1
Anonymous
Not applicable

up

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors