topic Re: Changing monthly table to 15 minutes values in DAX Commands and Tips

Changing monthly table to 15 minutes values

Anonymous — Wed, 14 Apr 2021 14:24:07 GMT

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)

I hope I explained the problem clear enough!

Re: Changing monthly table to 15 minutes values

amitchandak — Wed, 14 Apr 2021 17:08:17 GMT

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

Appreciate your Kudos.

Re: Changing monthly table to 15 minutes values

Jihwan_Kim — Wed, 14 Apr 2021 17:50:08 GMT

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.

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/

Re: Changing monthly table to 15 minutes values

Anonymous — Wed, 14 Apr 2021 21:24:30 GMT

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.

Re: Changing monthly table to 15 minutes values

Anonymous — Fri, 16 Apr 2021 13:19:41 GMT

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.

Re: Changing monthly table to 15 minutes values

Jihwan_Kim — Fri, 16 Apr 2021 13:35:58 GMT

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/

Re: Changing monthly table to 15 minutes values

Anonymous — Fri, 16 Apr 2021 13:38:13 GMT

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