Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
Super User
Super User

Hi, @Anonymous 

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/

 

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


Go to My LinkedIn Page


View solution in original post

6 REPLIES 6
Anonymous
Not applicable

@Anonymous 

 

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
Super User
Super User

Hi, @Anonymous 

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/

 

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


Go to My LinkedIn Page


Anonymous
Not applicable

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. 

 

 

Hi, @Anonymous 

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/

 

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


Go to My LinkedIn Page


Anonymous
Not applicable

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

amitchandak
Super User
Super User

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

Appreciate your Kudos.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors