Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
Resulting (year and month of table D_TIEMPO):
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:
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:
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.
As you can see the accumulated ("MP month Acu") does not have the correct numbers:
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.
Solved! Go to Solution.
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
actual days = DAY( Max(Table4[Date]))
total days = COUNTROWS('Calendar')
test = SUMX(VALUES('Calendar'[Month]),[projection])
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
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.
User | Count |
---|---|
134 | |
74 | |
73 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
63 | |
63 | |
51 |