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

Changing monthly table to 15 minutes values

Hi everyone,

 

I am very new to Power Bi. I have a data table with montly values and I want to change them to 15 minute values(so januari would have 31*24*4 rows and the value would be 38/(31*24*4) for every row in januari). These are theoretical values of solar panel yield and i want to compare it to the actual values(which are calculated every 15 minutes)

rkoning_0-1618409964348.png

 

I hope I explained the problem clear enough!

 

1 ACCEPTED SOLUTION
Jihwan_Kim
Community Champion
Community Champion

Hi, @rkoning 

I am not familiar with the case and your actual data model, but I prefer to have a separate Dim-Date-Table and Dim-Time-Table. Those will be connected to the future actual value table.

Please check the below picture and the sample pbix file's link down below, whether it suits your case.

The comparison table is created by using calculated measures because the total number of lines for one year will be 365days X 24 hours X 4(15min bin) = 35040 lines.

 

all measures are in the sample pbix file.

 

 

Picture6.pngPicture7.png

 

https://www.dropbox.com/s/o9ekimvfc9si9q5/rkoning.pbix?dl=0 

 

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

 

View solution in original post

6 REPLIES 6
daxer
Solution Sage
Solution Sage

@rkoning 

 

This is a job for Power Query. And it's really easy like hell 🙂 In PQ you can add a new column to this table and in the column in each row you can create - through M - a new table (that'll first be folded on creation) with the required number of rows. Then you can expand the tables in rows (through GUI). And voila! You have an expanded table with the number of rows for each month you require.

 

In any case, Power Query is your friend.

Jihwan_Kim
Community Champion
Community Champion

Hi, @rkoning 

I am not familiar with the case and your actual data model, but I prefer to have a separate Dim-Date-Table and Dim-Time-Table. Those will be connected to the future actual value table.

Please check the below picture and the sample pbix file's link down below, whether it suits your case.

The comparison table is created by using calculated measures because the total number of lines for one year will be 365days X 24 hours X 4(15min bin) = 35040 lines.

 

all measures are in the sample pbix file.

 

 

Picture6.pngPicture7.png

 

https://www.dropbox.com/s/o9ekimvfc9si9q5/rkoning.pbix?dl=0 

 

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

 

View solution in original post

Thanks! 

The sample contains exactly what i am looking for. How do I make those calendar and time tables? Still very new to the documentation etc. 

 

 

Jihwan_Kim
Community Champion
Community Champion

Hi, @rkoning 

Thank you for your feedback.

You can easily search to find those. Most of them provide you with M-code freely that you can use them to create Dim-Date-Table and Dim-Time-Table.

You can try to search for it on Youtube.

By the way, are you located in The Netherlands? I live in The Netherlands. 🙂

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

 

Thanks! ill give youtube a try then. Yes born and raised in Amsterdam!

amitchandak
Super User IV
Super User IV

@rkoning ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors