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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Syndicate_Admin
Administrator
Administrator

CUMULATIVE PRODUCTION PROJECTION

Greetings community, I have the following case.

I have my daily production progress ("Reconciled Height") in a "TAvanceDiario" table which is connected to a "D_TIEMPO" calendar table, the advance table is until 09/03/2022 and the D_TIEMPO table is until 31/12/2022. I calculate the advance days of each month and also the production progress of the month.

MiguelK13_3-1647092497156.png

MiguelK13_4-1647092730606.png

Resulting (year and month of table D_TIEMPO):

MiguelK13_5-1647092748654.png

My first objective is to project how the current month (March) will end, for this I have to calculate the days that the current month has:

MiguelK13_6-1647092840433.png

And then I calculate my Projected Production with a rule of three: I divide the advance by the days of advance and multiply it by the days that the month has:

MiguelK13_8-1647093193437.png

MiguelK13_9-1647093218767.png

So far so good, the production project for the month of March is 21,590.

My 2nd goal is to have the monthly cumulative, including my March projection. And that's where I have problems, since using the indicated formula gives me another value.

MiguelK13_10-1647093364160.png

MiguelK13_11-1647093400076.png

As you can see the accumulated ("MP month Acu") does not have the correct numbers:

MiguelK13_12-1647093573491.png

I don't know what to do anymore, with this topic, I was thinking about creating another table with summarize but it doesn't work for me either. Help please.

Thank you very much for your time.

1 ACCEPTED SOLUTION
Vera_33
Resident Rockstar
Resident Rockstar

Hi @Syndicate_Admin 

 

Do you have a filter on Month? So you have Jan, Feb, Mar only, and you only have 2022?

Modify your measures a little bit, you are looking at test & test2, test is calling your projection meausre, test2 is calling test

Vera_33_0-1647177653192.png

actual days = DAY( Max(Table4[Date]))

total days = COUNTROWS('Calendar')

test = SUMX(VALUES('Calendar'[Month]),[projection])

 

View solution in original post

2 REPLIES 2
Vera_33
Resident Rockstar
Resident Rockstar

Hi @Syndicate_Admin 

 

Do you have a filter on Month? So you have Jan, Feb, Mar only, and you only have 2022?

Modify your measures a little bit, you are looking at test & test2, test is calling your projection meausre, test2 is calling test

Vera_33_0-1647177653192.png

actual days = DAY( Max(Table4[Date]))

total days = COUNTROWS('Calendar')

test = SUMX(VALUES('Calendar'[Month]),[projection])

 

Si tengo un filtro de mes y de año de la tabla calendario.

He probado lo que me indicas, y si me funcionó. Excelente¡

a veces me hago un gran problema, y la solucion viene de manera simple.

 

Muchas gracias, por tu tiempo.

 

Saludos.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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