The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I have daily forecasts (for different brands) and I want to split each of them in hourly slots (from 8AM till midnight).
For each hour slot, I would likr to have the forecasts equally splitted.
Any tips for that?
Divide by 16?
Yes, my problem is to find the DAX sintax to assign each part to an hour.
E.g.: 160 --> 10 each hour (from 8-9, 9-10, 10-11, etc)
OK, perhaps sample data would be good because I am not understanding this. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Create a disconnected table with your axis values 8-9, 9-10, 10-11, 11-12
Measure = [Forecast]/16
Put measure in your visual and for each hour it will be the same value, your Forecast divided by 16
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
24 | |
14 | |
13 | |
10 | |
7 |