Subtract index numbers from water meters for actual consumption

[mendino]

Hi, Community Power bi

I would like to know how to solve the following problem? I have a table with number of days, the month, the year, the name of the various meters (12 in total), as well as its index in m3 of waterPour arriver à mon objectif je dois faire la soustraction par le relevé précédent.

In the case that I have a value per month, I can use the following formula by fessant a decrementation of -1 the month:

Conso = Table_vrai[Index]-LOOKUPVALUE(Table_vrai[Index];Table_vrai[compteur];Table_vrai[compteur];Table_vrai[Years];Table_vrai[Years];Table_vrai[Month];Table_vrai[Month]-1)

My problem is when I have multiple values in the month, how can I please?
I'm thinking of a formula that compares the month of the line to the lower month or if condition ?

Thank you

Regards,

[v-chuncz-msft · Accepted solution]

@mendino,

You may try to use SUMMARIZE Function to create a calculated table first.

[mendino · Accepted solution]

thank you for your reply.

I found one solution in site power bi.

" Calculate monthly consumption from daily meter reads"
https://community.powerbi.com/t5/Desktop/Calculate-monthly-consumption-from-daily-meter-reads/m-p/16...

I will tried later your solution
 

[v-chuncz-msft · Accepted solution]

@mendino,

You may try to use SUMMARIZE Function to create a calculated table first.

[mendino · Accepted solution]

thank you for your reply.

I found one solution in site power bi.

" Calculate monthly consumption from daily meter reads"
https://community.powerbi.com/t5/Desktop/Calculate-monthly-consumption-from-daily-meter-reads/m-p/16...

I will tried later your solution
 

[mendino]

Hello

I have another problem with this solution.
My table to multiple time  value. I have the years 2018 and 2017.

Conso Max Atif = Elec[Max actif]-LOOKUPVALUE(Elec[Max actif];Elec[compteurs];Elec[compteurs];Elec[Year];Elec[Year];Elec[Month];Elec[Month]-1)

I though put function IF

 Elec[Year];Elec[Year]-If(Elec[Year] <2018;+1;0);Elec[Month];Elec[Month]-If(Elec[Month]>2017;+1;0)

I not understant why does not work ?

Please help.

Regards,

[mendino · Accepted solution]

Hello, I have find solution

Conso Max Atif = Elec[Max actif]-LOOKUPVALUE(Elec[Max actif];Elec[compteurs];Elec[compteurs];Elec[Année];IF(Elec[Mois]=1;2017;2018);Elec[Mois];IF(Elec[Mois]=1;Elec[Mois]+11;Elec[Mois]-1))