Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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