Forum Discussion
Average Consum(kWh) per day
Hi,
Can someone help me with this please.
I must create a line visualisation showing the sum of Consum(kWh) per Day.
But when looking at that for a month, it needs to be the average of the values for each day of that month.
I have my Calendar Table:
'Calendar'[Year],
'Calendar'[Quarter]
'Calendar'[Month]
'Calendar'[Date]
My FACT TABLE has columns:
'FACT TABLE'[Consum(kWh)]
'FACT TABLE'[Start Date]
'FACT TABLE'[SDR ID] - this is my Unique ID column
'FACT TABLE'[CP ID] - this is my Charger Sessions column
Thank you greatly if you can work this out.
Best,
J
Anonymous
MeasureAvg.Sum kWh per day = AVERAGEX ( SUMMARIZE ( 'FACT TABLE', 'Calendar'[Year], 'Calendar'[Quarter], 'Calendar'[Month Name], 'Calendar'[Date] ), CALCULATE ( SUM ( 'FACT TABLE'[Consum(kWh)] ) ) )
2 Replies
Anonymous
MeasureAvg.Sum kWh per day = AVERAGEX ( SUMMARIZE ( 'FACT TABLE', 'Calendar'[Year], 'Calendar'[Quarter], 'Calendar'[Month Name], 'Calendar'[Date] ), CALCULATE ( SUM ( 'FACT TABLE'[Consum(kWh)] ) ) )