cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Medir para aportar el valor del primer y último día del mes

Hola

Me gustaría crear una medida que me permita aportar el valor de "Total Diesel in Tanks" para el primer día y el último día del mes (1 de septiembre y 30 de septiembre).

LuisGerardoSR_0-1601417430645.png

¡Gracias!

1 ACCEPTED SOLUTION
Super User II
Super User II

@LuisGerardoSR

Si tiene una dimensión Tabla de fechas, puede intentar lo siguiente:

valor en el 1er del mes : CALCULATE(SUM(table[Total Diesel in Tanks]), STARTOFMONTH(Date Table[Date]))

valor en el último día del mes ?
CLOSINGBALANCEMONTH(SUM(table[Total Diesel in Tanks]), Tabla de Fechas[Fecha])





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

1 REPLY 1
Super User II
Super User II

@LuisGerardoSR

Si tiene una dimensión Tabla de fechas, puede intentar lo siguiente:

valor en el 1er del mes : CALCULATE(SUM(table[Total Diesel in Tanks]), STARTOFMONTH(Date Table[Date]))

valor en el último día del mes ?
CLOSINGBALANCEMONTH(SUM(table[Total Diesel in Tanks]), Tabla de Fechas[Fecha])





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.