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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bhatfield
Regular Visitor

Use previous total with blank cumulative data

I am running aggregate totals based on GL for one of my reports. There is a gap in entries for a few periods where i would like to carry the previous periods amount if there were no transactions that period. Cant seem to get the logic after the initial cumulative code.  THanks

 

bhatfield_0-1663684070604.png

 

5 REPLIES 5
bhatfield
Regular Visitor

I am sorry i shouldve been more specific. I do not have an issue with the cumulative total rather when i try to break out the individual GLs and there is no entry for that specific period. This example shows me filtering the cumulative total and in period 6 there is no value so in the table it shows up as blank where i want it to show 27480.48 until period 7 where there is a new entry

bhatfield_0-1663685480072.png

 

PabloDeheza
Solution Sage
Solution Sage

Hi there!

For cumulative sum you try this:

CALCULATE (
    SUM ( ColumnToSum ),
    FILTER (
        ALL ( DateTable ),
        DateTable[Date] <= MAX ( DateTable[Date] )
    )
)

Let me know if that helps!

amitchandak
Super User
Super User

@bhatfield , The FiscalProfilePeriod should be a separate table like the date table. and period on axis should also come from FiscalProfilePeriod 

 

and use all on table in place of table column

 

filter(all(FiscalProfilePeriod ), <rest of the code >

i figured it out

 

bhatfield_0-1663686355555.png

 

 

those dates are from a profile that is fiscal period the date table is separate from them

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors