I need to convert 15 mins interval into 1 day in a month .
For example i have data as shown in the dig,
I need to add all Kwh column from 1/1/2016 till 31/1/2016 ( which includes the 15 time interval), similarly for next month as shown in the dig.
I have attached the required screen shot.
Go to Solution.
Should you opt for a Power Query solution, then transform your date column to the date of the end of the month (menu options: transform tab - Date - Month - End Of Month).
Group By these dates and choose operation "Sum" for your Kwh column.
You can add a calculated Column to get Month End for each Date.
Then you can use Month End Date to do the Pivot Table
EOMONTH ( TableName[Date], 0 )
I do not see how the 15 min interval has anything to do with this. Seems like you should just be able to create a table visualization that includes [Date] and the SUM of KwH. If you need a table, use SUMMARIZE.
Proud to be a Datanaut!
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.