this is nice, learned this a few years back. perhaps you can add to this the positives and negatives of continuous vs categorical. and does it matter if you use start or end of month? i use end. And is there user education needed when you hover over data points? I struggle with making dynamic charts that will correspond to the date range selected. ie I have book marks for All Years, CY , CY-1, Last Month Current Month, Last 10 days. Each trys to display chart and matrix for that matter in correct manner. ie Last 10 days, CM and LM drill down to day level. All Years show continuous, CY shows my month
One thing to be aware of as well: on small capacities you are very limited in concurrent spark sessions, so a long running notebook will block other notebooks or Lakehouses.
There is a link in the description of the video, but I will also share it here:www.obvience.com/time-series-forecasting There if you go through the lesson, you will find the link to the PowerBI Desktop models for the start and the end of the exercise
Hi, I just wanted to say "Thanks" for taking the time to make this Hands-on Course & share the Data Model. It took me a while to figure, why your Seasonality Dax code was not working in my model: Your "Revenue Data" is already grouped by "Start of Week" Date and not on a daily basis. Might be helpful for others too.
You are very welcome.. the data in the fact table is at the week grain, but if you have a week start date in the date dimension, then you just drag that into your chart and the rest of the calc should work in any scenario, having a month start date and week start date attributes in your Date dimensions come in very handy
@@KnowledgeBankPro Ok. I will check. But as far as my Dax knowledge goes, it is not so easy to sum up the"Sales Forecast" Results on monthly or quarterly base (because both measures are calculated on weekly base) Or am I mistaking here?
@@Frentzenable the only dependency is what is the grain of your Actuals. As long as it's daily, you can easily make it weekly or monthly, but just dragging WeekStartDate or MonthStartDate from the Date dimension, that will convert your actuals to Weekly or Monthly and then you can use my logic for forecast
Not exactly what I was looking for. However, it did help me a great deal. I am trying to replicate pipeline created by data engineer couple of years ago (they have left since then). In place of arm template deployment, they are using Copy Files to X location and then Publish Artifact. Not sure, how that works but your video helped me understood other things around that.
That was a good post . But how to create a table with 4 wks 8wks and 16 wks data . Also table with current 4 wks vs previous 4wk comparision . Is it possible to create a date hierarchy for 4,8and 12 so that we can show it in single chart and enable hierarchy
Hello If you grant someone role access (apparently the read access) to some of the tables in a lakehouse from another workspace, will he be able to create a custom semantic model where for example he can define relationship that didn't exist between the tables in the original lakehouse?
Hello, if i am using one lakehouse as a single source of truth for several teams, which each one of them would require accessing a subset of the tables found in the lakehouse. The one lakehouse would be in a workspace A, and the user will reading the specified tables from workspaces B,C,D,.... where they will be also building their power bi reports. is it better to go with the role based data access, or to create a separate lakehouses in the Workspaces B,C,D,..... where i will be creating shortcuts with the subset of tables needed for their reporting needs? Thanks
I dearly liked this method and everyone was amazed. The only challenge I have is that my breakdowns are not sorting. Does anyone know what could be the problem. The sort column data type is whole number
Thanks for the video. I have tried using the data activator by setting an alert from a card visual. However, I am not able to create a new property from a field from the same semantic model to the same alert. Also, not sure how to integrate this trigger to power automate. Currently the users in the email list should have the same domain as the alert owner. I tried by adding an AD group with multiple domain users and didn't work. Is there any workaround you can think of, it would be appreciated.
Hey New Subscriber to you with your Amazing Lesson on Forecasting.. And could you please make a video on IMPORTANT DAX Calculations & SQL Quick tips for Preparing Data Analyst interview Thank you!
Hey and thans a lot for this amazing feature Great success to have a seasonal forecast at month level When displaying it on a graph for 2024 it is perfect (with mensual datas from january 2022 as inputs) Unfortunately, i want to project the forecast cumulative sum at end of 2024 but it doesnt work with classical function as SUMX because it made some mistakes with forecasted measures Do you have a solution for this ?
Just started with a trial of Inforiver in Power BI and your Tutorials are a great starting point. Would like to see a Tutorial in writing formulas in Inforiver comparing Actual Data vs. Forecast Data, Total etc. I am struggling to address columns correct.
Thank you for sharing. I haven't played with it yet. I'd like to ask regarding 'weeklyData' variable. Why Addcolumns is wrapped in CALCULATETABLE with ALL('Date') modifier? What purpose does it serve?
that's my todo for this week, I can't share the PBIX because it has customer data, so I will have to create a new one and publish it. Hopefully I will have some time over the weekend. And thank you for the website compliment!
Thanks for your time. Unfortunately, results from "Sales Forecast" Measure are off. Is the logic / Dax for "Sales Forecast - Seasonality" ok? EDIT: I think the logic of summing up all prior years could be misleading in growing business.
yes, the video is really more of a way to get creative juices going to think for new and exciting ways to use Power BI and DAX for scenarios that we may not have considered before. I am hoping to have a PBIX that I can share ready this weekend so folks can play with the working measure.
I just love how youve been able to do time series forecasting with DAX. Just amazing!! Is it possible to share the pbix file or just the sales data on your blog just to follow along
Very nice, but I am not able to get this working. In the Measure "Sales Forecast - Trend" from your Blog, i get the message: Can not find name [Slope1]. Any idea? Where is this defined? Thanks in advance!
Good morning Sir I Built an Organization Chart with performance flow. I´m having an issue, the images are not showing up. How you did you upload those images on your chart, could you tell me please?
That was added so that the trend starts where the actuals end, otherwise it starts with period one again, that was the error that i noticed during editing of the video
unfortunately, you have to have a fabric capacity, and not any capacity, it has to be big enough to support Copilot, which I believe is F64 and above...