cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
siva3012 Regular Visitor
Regular Visitor

Transform 15 Mins interval data into days ?

Hi Folks,

 

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.

 

15.jpg

 

1 ACCEPTED SOLUTION

Accepted Solutions
MarcelBeug Super Contributor
Super Contributor

Re: Transform 15 Mins interval data into days ?

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.

Specializing in Power Query Formula Language (M)
3 REPLIES 3
Super User
Super User

Re: Transform 15 Mins interval data into days ?

Hi @siva3012

 

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

 

Month_End =
EOMONTH ( TableName[Date], 0 )

1056.png

Super User
Super User

Re: Transform 15 Mins interval data into days ?

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.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

MarcelBeug Super Contributor
Super Contributor

Re: Transform 15 Mins interval data into days ?

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.

Specializing in Power Query Formula Language (M)

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 279 members 2,960 guests
Please welcome our newest community members: