Month to month Difference Issues with calculation

[Anonymous]

Hi everyone.

I'm really struggling with a problem i Power BI in which i want to showcase data from gathering of data from electrical meters.

The data is collected over a span off 4 years 2015-2019, and i want to showcase both the yearly change and be able to drilldown into montly change (numeric change).

My dataset is an excel exported from the system which contains the Meters name/number, date and time of the registration of the metervalue (dd-mm-yyyy + time), and last the actualt reading of the meter.

- as it is a meter the value will always be equal or bigger than 0, so in March in might be 1000KW and next month 1100KW.  PowerBI recognises the Hieraki from the date value and puts it into Year, Quater, Month, Date.

I've tried this calculation but it has some problems.

"Difference= sum(report[reading])-CALCULATE(sum(report[Reading]);PREVIOUSMONTH(Report[date og Time].[Date]))"

First of all

My big issue is this - It's not guarantered that i have a reading every month, so if month 1=100, month 2=no reading, month 3=110, the answer for the difference will be 110 and not 10 which is the actual change. And then to make it even more complicated i can have two readings in some months.

Second it doesn't really work when looking at yearly change since it sums the values in some way which makes no sense.

I hope someone can help.

[v-piga-msft]

Hi @Anonymous ,

To understand your scenario better, could you please share some data sample which could reproduce your scenario and your desired output so that we could help further on it?

Best Regards,

Cherry

[Anonymous]

Hi @v-piga-msft.

This link is a small sample of the full data set.

https://transfernow.net/341lc2d5sric

[v-piga-msft]

Hi @Anonymous ,

Sorry for the delay.

It seems that your link has been expired, could you upload it again. In addition, you'd better share your desired output so that we could understand your scenario better.

Best  Regards,

Cherry

[Anonymous]

Hi @v-piga-msft.

New link: https://transfernow.net/74c32265pucn

I would like to be able to see the development over months and years, hence the change in values. But the problem is that some months has 2 registrations, which the latest value should be used and some months have 0 registrations (as you can see in the example). But in the month with 0 registration it should not show a minus development but just 0 in change, since it is a Measurement of used power, hence the value can only rise.

Optimally i would like to see a bar chart with the KW development pr. month in which the month with 0 registrations should either be showed as 0 or just filtered away.

I hope that makes it clar.