Forum Discussion
Display diffrence for time series using time as a filter
Hi everyone, i'm trying to create a dashboard for electrical meter with more user friendly. My aim is to display energy consumption value, that have to be diffrence of starting date and ending date by using timecreated as filter . If this get successuser can easily come to know daily, weekly, monthly and year consumption by simply adjusting the filter.
I'm using direct query techique, so data will be update automatically, Please help me to do it. Above pictures are live timestamp and corresponding value, and filter i want to use.
2 Replies
HI PraveenRaj,
According to your snapshot, you have a table contain created date time and corresponded electrical meter value, right?
if this is a case, you can create a data slicer with between model, then write a measure to calculate the different first record and last record.
Measure = CALCULATE ( MAX ( Table[M1RealEnergyEB] ) - MIN ( Table[M1RealEnergyEB] ), VALUES ( Table[DateCreated] ) )>>If this get successuser can easily come to know daily, weekly, monthly and year consumption by simply adjusting the filter.
I'd like to suggest you create a calendar table with detail units(date, days, weeknum, month, year), the build relationship to original table with date column. After these, you can drag calendar fields and above measure to create a matrix visual to show summarize result.
If not help, share some sample that we can test and coding formula on it.
Regards,
Xiaoxin Sheng
Hi Anonymous,
Your Measure working perfectly, but i have confusion how to create calendar matrix, I attached Meter1 and Meter 2 sample data for you, like this there are 11 electrical meter present in our site, suggest me to create better visualization. My aim is to display real, reactive and apparent energy consumption of 11 electrical meter by daily, weekly, monthly and yearly.
