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
• 7,480 points
41 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 12,110 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
• 35,720 points
41 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
• 35,720 points
53 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
• 7,480 points
431 views
0 votes
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 21, 2018 in Power BI by nirvana
• 3,040 points
342 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,100 points

edited Oct 11, 2018 by Kalgi 85 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
• 35,720 points
41 views
0 votes
1 answer

Power BI Dax Multiple IF AND Statements

I suspect your issue is that alphabetically ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 35,720 points
3,561 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
• 35,720 points
1,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
• 12,110 points
24 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
• 12,110 points
193 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.