Calculate DTD by hour

[Anonymous]

Hello.

My first post here, so please be patient with me. Also a newbie with PowerBI.

I have daily data of bookings by hour. I need to run a DTD summary.

The column I'm looking for should look something like in the picture.

Hope you guys can help.

[v-xicai · Accepted solution]

Hi @Anonymous ,

You can create columns Day_Num and bookings_DTD.

Day_Num = DAY(Table1[data_zal])

bookings_DTD = CALCULATE(SUM(Table1[bookings]),FILTER(ALLSELECTED(Table1),Table1[Day_Num]=EARLIER(Table1[Day_Num])&&Table1[data_zal]<=EARLIER(Table1[data_zal])))

 

Here is my test pbix: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EdNNbkfk9jpNjs4lBxRxB6oBXrzkCgx3uDz-S-_h5rjIQg?e=zXUxGx

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.