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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Brotedo
Helper I
Helper I

Cumulative Sum for PY and CY on Same Chart

I want a cumulative line chart for PY and CY sales on the same visual. I have it working right now, except I want PY sales to show for the whole year, not just YTD like CY sales are. So, it looks like this:

Brotedo_0-1665419641056.png

but I want to see all of the previous year sales.

This is my measure right now.

IncentiveSumTestPY = 
var yearnum = LOOKUPVALUE('dw dimDate'[YearNum],'dw dimDate'[FullDate], today())


RETURN

    if(max('dw dimDate'[FullDate])>today(), blank(),
    
    CALCULATE(sum('dw factSales'[IncentiveSales]), filter(all('dw dimDate'), 'dw dimDate'[DayNumOfYear]<=max('dw dimDate'[DayNumOfYear])),'dw dimDate'[YearNum]=yearnum-1
    
    
    
    ))

 

1 ACCEPTED SOLUTION
Brotedo
Helper I
Helper I

Nevermind, I solved this myself. 

View solution in original post

1 REPLY 1
Brotedo
Helper I
Helper I

Nevermind, I solved this myself. 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.