cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gabrielpibx
New Member

Creating a mesure that operates two lines of the same columm

I have a columm with the agragation of all consumation called "leitura" and i need to creat a mesure that calculates the consumation per day. Can i create this mesure using only this columm and the columm of date in the same table? The operation will be something like, the latest date minus the previous day and i need to calculate it for all period of time in the table. The table im referring is below

 

d1ec1eee-2e00-442c-ab36-fdf03d9ee97a.png   

So far im using this code: 

CD =
CALCULATE (
    VAR LEITURADODIA = LASTDATE('Hidrômetros'[Inserção])
    VAR LEITURADODIAANTERIOR = PREVIOUSDAY(LASTDATE('Hidrômetros'[Inserção]))
    RETURN
     IF([DATEDIFF]=0,"",
     SUMX('Hidrômetros',CALCULATE([VALORLEITURA],'Hidrômetros'[Inserção]=LEITURADODIA)- CALCULATE([VALORLEITURA],'Hidrômetros'[Inserção]=LEITURADODIAANTERIOR))),
     'Hidrômetros'[Apelido]="Macromedidor"
)


But i only got the result for the two last days in the table.  

1 REPLY 1
lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors