Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to Solution.
You may try to use SUMMARIZE Function to create a calculated table first.
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
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))
You may try to use SUMMARIZE Function to create a calculated table first.
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
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,
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))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |