Power BI Creating time factors

0 votes

I usually have data updates on an hourly basis. I would like to format and view the mean of these values across different time factors. Such as daily, weekly, monthly, nightly (9 pm to 6 am) and so on.

I've looked at splices and the DAX formatting of new columns and been playing around with that - but so far been unsuccessful.

Data example

Date                Value
28-06-2016 01:00    1
28-06-2016 02:00    1
28-06-2016 03:00    6
28-06-2016 04:00    9
28-06-2016 05:00    15
28-06-2016 06:00    17
28-06-2016 07:00    18
28-06-2016 08:00    21
28-06-2016 09:00    25
28-06-2016 10:00    30
28-06-2016 11:00    38
28-06-2016 12:00    41
28-06-2016 13:00    43
28-06-2016 14:00    45
28-06-2016 15:00    50
28-06-2016 16:00    57
28-06-2016 17:00    58
28-06-2016 18:00    60
28-06-2016 19:00    70
28-06-2016 20:00    77
28-06-2016 21:00    85
28-06-2016 22:00    85
28-06-2016 23:00    91
29-06-2016 00:00    91
29-06-2016 01:00    97
29-06-2016 02:00    99
29-06-2016 03:00    99
29-06-2016 04:00    100
29-06-2016 05:00    104
29-06-2016 06:00    113
29-06-2016 07:00    122
29-06-2016 08:00    125
29-06-2016 09:00    126
29-06-2016 10:00    134
29-06-2016 11:00    143
29-06-2016 12:00    150
29-06-2016 13:00    158
29-06-2016 14:00    162
29-06-2016 15:00    171
29-06-2016 16:00    174
29-06-2016 17:00    179
29-06-2016 18:00    181
29-06-2016 19:00    185
29-06-2016 20:00    195
29-06-2016 21:00    197
29-06-2016 22:00    203
29-06-2016 23:00    205

Nov 30, 2018 in Power BI by Upasana
• 8,620 points
569 views

1 answer to this question.

0 votes

Go to Edit Queries window of Power BI Desktop. This component was formerly known as Power Query back when it was just an Excel Add-In.

In Edit Queries / PQ, there is a richer set of Date functions that should meet your requirements.

answered Nov 30, 2018 by Shubham
• 13,490 points

Related Questions In Power BI

0 votes
1 answer

Real time power bi dashboard update without refreshing the browser

The only solution possible by code - ...READ MORE

answered Sep 28, 2018 in Power BI by Kalgi
• 52,360 points
1,575 views
0 votes
1 answer

Few tips before I start creating Power BI dashboard

It’s always advisable to begin with the data ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,360 points
699 views
0 votes
1 answer

Time Series Chart in Power BI

Your Date format should be handled by ...READ MORE

answered Nov 26, 2018 in Power BI by Upasana
• 8,620 points
4,186 views
0 votes
1 answer

Creating a stacked chart from 1 column in Power BI

Hi @Veronicabello, Follow the below steps: 1. Create a ...READ MORE

answered Aug 3, 2020 in Power BI by Reshma
1,454 views
+3 votes
2 answers

Combine tables in Power BI

You can also achieve this using a ...READ MORE

answered Oct 5, 2018 in Power BI by lina
• 8,220 points

edited Oct 11, 2018 by Kalgi 2,097 views
0 votes
1 answer

Power Bi Dax Table

You need to wrap the numbers in ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 52,360 points
931 views
0 votes
2 answers

Power BI Dax Multiple IF AND Statements

HI I have Column Patient 12 13 14 15 18 IN Patient=12, 13 Out ...READ MORE

answered May 23, 2019 in Power BI by VNK
18,425 views
0 votes
1 answer

Distinct count filtered by condition using Power BI Dax

Try this, it should work: DistinctCountActiveMonths = CALCULATE( ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 52,360 points
36,935 views
0 votes
1 answer

Power BI : Time-based drill downs powered by Azure Data Warehouse

I don't really think you need to ...READ MORE

answered Oct 29, 2018 in Power BI by Shubham
• 13,490 points
635 views
0 votes
1 answer

Embedding Power Bi Report Promise is not defined powerbi.js

IE does not yet support Promise. You ...READ MORE

answered Oct 30, 2018 in Power BI by Shubham
• 13,490 points
1,760 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP